DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 1567: FROM PO_REQ_DISTRIBUTIONS PRD,

1563: --spangulu 09/16/2003
1564: --added distribution_type for encumb. rewrite
1565: PLL.shipment_type,
1566: PH.Org_Id --
1567: FROM PO_REQ_DISTRIBUTIONS PRD,
1568: PO_REQUISITION_LINES PRL,
1569: PO_HEADERS PH,
1570: PO_LINE_LOCATIONS PLL
1571: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id

Line 2419: po_req_distributions prd,

2415: BEGIN
2416: SELECT prh.segment1, prl.line_num
2417: INTO x_req_num, x_req_line_num
2418: FROM po_distributions pod,
2419: po_req_distributions prd,
2420: po_requisition_lines prl,
2421: po_requisition_headers prh
2422: WHERE pod.po_distribution_id = p_po_distribution_id
2423: AND pod.req_distribution_id = prd.distribution_id

Line 2566: PO_REQ_DISTRIBUTIONS PRD

2562: FROM PO_REQUISITION_LINES PRL,
2563: PO_LINE_LOCATIONS POLL,
2564: PO_LINES POL,
2565: PO_DISTRIBUTIONS PD,
2566: PO_REQ_DISTRIBUTIONS PRD
2567: WHERE POLL.line_location_id = p_line_location_id
2568: AND POLL.po_line_id = POL.po_line_id
2569: AND PRL.unit_price >= 0
2570: AND POLL.line_location_id = PD.line_location_id