APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 491: -- PO_REQ_DISTRIBUTIONS_ALL

487: --Modifies:
488: -- PO_ENCUMBRANCE_GT
489: --Locks:
490: -- PO_REQUISITION_HEADERS_ALL
491: -- PO_REQ_DISTRIBUTIONS_ALL
492: -- PO_HEADERS_ALL
493: -- PO_RELEASES_ALL
494: -- PO_DISTRIBUTIONS_ALL
495: --Function:

Line 972: -- PO_REQ_DISTRIBUTIONS_ALL

968: --Modifies:
969: -- PO_ENCUMBRANCE_GT
970: --Locks:
971: -- PO_REQUISITION_HEADERS_ALL
972: -- PO_REQ_DISTRIBUTIONS_ALL
973: -- PO_HEADERS_ALL
974: -- PO_RELEASES_ALL
975: -- PO_DISTRIBUTIONS_ALL
976: --Function:

Line 1857: -- PO_REQ_DISTRIBUTIONS_ALL

1853: --Modifies:
1854: -- None.
1855: --Locks:
1856: -- PO_DISTRIBUTIONS_ALL
1857: -- PO_REQ_DISTRIBUTIONS_ALL
1858: --Function:
1859: -- Locks all of the backing distributions of the given type that are
1860: -- referenced by main doc rows in the encumbrance table.
1861: --Parameters:

Line 2091: , PO_REQ_DISTRIBUTIONS_ALL PRD

2087: , PRD.distribution_id
2088: FROM
2089: PO_ENCUMBRANCE_GT ENC
2090: , PO_REQUISITION_LINES_ALL PRL
2091: , PO_REQ_DISTRIBUTIONS_ALL PRD
2092: WHERE PRD.distribution_id = ENC.req_distribution_id --JOIN
2093: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN
2094: AND NVL(PRD.prevent_encumbrance_flag,'N') = 'N'
2095: AND NVL(PRL.closed_code,g_clsd_OPEN) <> g_clsd_FINALLY_CLOSED

Line 2174: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

2170:
2171: UPDATE PO_SESSION_GT SCRATCH
2172: SET SCRATCH.num3 =
2173: ( SELECT PRD.distribution_id
2174: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
2175: WHERE PRD.source_req_distribution_id = SCRATCH.num2
2176: )
2177: WHERE SCRATCH.key = l_backing_req_key
2178: ;

Line 7790: FROM PO_REQ_DISTRIBUTIONS_ALL REQ_TABLE

7786:
7787: UPDATE PO_ENCUMBRANCE_GT BACKING_REQ
7788: SET reference14 =
7789: (SELECT REQ_TABLE.source_req_distribution_id
7790: FROM PO_REQ_DISTRIBUTIONS_ALL REQ_TABLE
7791: WHERE BACKING_REQ.distribution_id = REQ_TABLE.distribution_id
7792: )
7793: WHERE BACKING_REQ.origin_sequence_num IS NOT NULL
7794: AND BACKING_REQ.distribution_type = g_dist_type_REQUISITION

Line 7805: FROM PO_REQ_DISTRIBUTIONS_ALL PARENT_DIST

7801:
7802: UPDATE PO_ENCUMBRANCE_GT MAIN_REQ
7803: SET reference14 =
7804: (SELECT PARENT_DIST.distribution_id
7805: FROM PO_REQ_DISTRIBUTIONS_ALL PARENT_DIST
7806: , PO_REQUISITION_LINES_ALL PARENT_LINE
7807: , PO_REQUISITION_LINES_ALL CHILD_LINE
7808: WHERE MAIN_REQ.line_id = CHILD_LINE.requisition_line_id
7809: AND PARENT_LINE.requisition_line_id = CHILD_LINE.parent_req_line_id