DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 1551: FROM PO_REQ_DISTRIBUTIONS PRD,

1547: --spangulu 09/16/2003
1548: --added distribution_type for encumb. rewrite
1549: PLL.shipment_type,
1550: PH.Org_Id --
1551: FROM PO_REQ_DISTRIBUTIONS PRD,
1552: PO_REQUISITION_LINES PRL,
1553: PO_HEADERS PH,
1554: PO_LINE_LOCATIONS PLL
1555: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id

Line 2394: po_req_distributions prd,

2390: BEGIN
2391: SELECT prh.segment1, prl.line_num
2392: INTO x_req_num, x_req_line_num
2393: FROM po_distributions pod,
2394: po_req_distributions prd,
2395: po_requisition_lines prl,
2396: po_requisition_headers prh
2397: WHERE pod.po_distribution_id = p_po_distribution_id
2398: AND pod.req_distribution_id = prd.distribution_id

Line 2541: PO_REQ_DISTRIBUTIONS PRD

2537: FROM PO_REQUISITION_LINES PRL,
2538: PO_LINE_LOCATIONS POLL,
2539: PO_LINES POL,
2540: PO_DISTRIBUTIONS PD,
2541: PO_REQ_DISTRIBUTIONS PRD
2542: WHERE POLL.line_location_id = p_line_location_id
2543: AND POLL.po_line_id = POL.po_line_id
2544: AND PRL.unit_price >= 0
2545: AND POLL.line_location_id = PD.line_location_id