APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 488: -- PO_REQ_DISTRIBUTIONS_ALL

484: --Modifies:
485: -- PO_ENCUMBRANCE_GT
486: --Locks:
487: -- PO_REQUISITION_HEADERS_ALL
488: -- PO_REQ_DISTRIBUTIONS_ALL
489: -- PO_HEADERS_ALL
490: -- PO_RELEASES_ALL
491: -- PO_DISTRIBUTIONS_ALL
492: --Function:

Line 969: -- PO_REQ_DISTRIBUTIONS_ALL

965: --Modifies:
966: -- PO_ENCUMBRANCE_GT
967: --Locks:
968: -- PO_REQUISITION_HEADERS_ALL
969: -- PO_REQ_DISTRIBUTIONS_ALL
970: -- PO_HEADERS_ALL
971: -- PO_RELEASES_ALL
972: -- PO_DISTRIBUTIONS_ALL
973: --Function:

Line 1819: -- PO_REQ_DISTRIBUTIONS_ALL

1815: --Modifies:
1816: -- None.
1817: --Locks:
1818: -- PO_DISTRIBUTIONS_ALL
1819: -- PO_REQ_DISTRIBUTIONS_ALL
1820: --Function:
1821: -- Locks all of the backing distributions of the given type that are
1822: -- referenced by main doc rows in the encumbrance table.
1823: --Parameters:

Line 2053: , PO_REQ_DISTRIBUTIONS_ALL PRD

2049: , PRD.distribution_id
2050: FROM
2051: PO_ENCUMBRANCE_GT ENC
2052: , PO_REQUISITION_LINES_ALL PRL
2053: , PO_REQ_DISTRIBUTIONS_ALL PRD
2054: WHERE PRD.distribution_id = ENC.req_distribution_id --JOIN
2055: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN
2056: AND NVL(PRD.prevent_encumbrance_flag,'N') = 'N'
2057: AND NVL(PRL.closed_code,g_clsd_OPEN) <> g_clsd_FINALLY_CLOSED

Line 2136: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

2132:
2133: UPDATE PO_SESSION_GT SCRATCH
2134: SET SCRATCH.num3 =
2135: ( SELECT PRD.distribution_id
2136: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
2137: WHERE PRD.source_req_distribution_id = SCRATCH.num2
2138: )
2139: WHERE SCRATCH.key = l_backing_req_key
2140: ;

Line 7392: FROM PO_REQ_DISTRIBUTIONS_ALL REQ_TABLE

7388:
7389: UPDATE PO_ENCUMBRANCE_GT BACKING_REQ
7390: SET reference14 =
7391: (SELECT REQ_TABLE.source_req_distribution_id
7392: FROM PO_REQ_DISTRIBUTIONS_ALL REQ_TABLE
7393: WHERE BACKING_REQ.distribution_id = REQ_TABLE.distribution_id
7394: )
7395: WHERE BACKING_REQ.origin_sequence_num IS NOT NULL
7396: AND BACKING_REQ.distribution_type = g_dist_type_REQUISITION

Line 7407: FROM PO_REQ_DISTRIBUTIONS_ALL PARENT_DIST

7403:
7404: UPDATE PO_ENCUMBRANCE_GT MAIN_REQ
7405: SET reference14 =
7406: (SELECT PARENT_DIST.distribution_id
7407: FROM PO_REQ_DISTRIBUTIONS_ALL PARENT_DIST
7408: , PO_REQUISITION_LINES_ALL PARENT_LINE
7409: , PO_REQUISITION_LINES_ALL CHILD_LINE
7410: WHERE MAIN_REQ.line_id = CHILD_LINE.requisition_line_id
7411: AND PARENT_LINE.requisition_line_id = CHILD_LINE.parent_req_line_id