Need Join Condition for BIAPPS Warehouse Tables

Question

W_PURCH_COST_FW_PURCH_RCPT_FW_AP_HOLDS_FW_AP_XACT_FW_PROJ_EXP_LINE_FW_PURCH_RQSTN_LINE_FW_PROJ_INVOICE_DIST_FW_PROJ_INVOICE_LINE_F

Hello,

I am new to BIAPPS and need to create a query using BIAPPS Warehouse facts:

W_PURCH_COST_F,W_PURCH_RCPT_F,W_AP_HOLDS_F,W_AP_XACT_F,W_PROJ_EXP_LINE_F,W_PURCH_RQSTN_LINE_F,W_PROJ_INVOICE_DIST_F,W_PROJ_INVOICE_LINE_F.

can somebody please provide me a query for the same?

Thanks in advance

Thomas Dodds · Answer

How are these joined in the RPD?  you are better off following Oracle's example (from the RPD) and since you purchased apps you have that RPD and all you need to answer the question.