Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Monday, January 10, 2011

[PO] Backend Field for PR

We know that we can view Purchase Requisition (PR) number from PO distribution screen (Line -> Shipment -> Distributions, for standard PO). Which field in the backend table is used to link to PR tables?

Ans: LINE_LOCATION_ID field in APPS.PO_LINE_LOCATIONS_ALL table that links to APPS.PO_REQUISITION_LINES_ALL table

No comments:

Post a Comment