CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

PR and RFQ Table Relationship...

Hi everybody,

I have derived the Requisition No. of Purchase order in PO Report by relating PO tables and Requisition tables.

But by the same way when I try to derive the Requisition No. for any RFQ , I am not getting the Requisition No. of that RFQ .

I am using the following tables to get the requisition no.

1)         PO_REQUISITION_HEADERS_ALL

2)         PO_REQUISITION_LINES_ALL

3)         PO_REQ_DISTRIBUTIONS_ALL

4)         PO_DISTRIBUTIONS_ALL 

 

If anyone knows about the table relationship of requisition and RFQ please give me some guidelines to link PR and RFQ.   

If anyone knows about the table relationship of requisition and RFQ please give me some guidelines to link PR and RFQ. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center