APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_REQUISITION_LINES_ALL

Line 217: PO_REQUISITION_LINES_ALL.source_type_code%TYPE

213:
214:
215: -- source type codes
216: g_src_INVENTORY CONSTANT
217: PO_REQUISITION_LINES_ALL.source_type_code%TYPE
218: := 'INVENTORY'
219: ;
220:
221:

Line 2090: , PO_REQUISITION_LINES_ALL PRL

2086: , ENC.sequence_num
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'

Line 7806: , PO_REQUISITION_LINES_ALL PARENT_LINE

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
7810: AND PARENT_DIST.requisition_line_id = PARENT_LINE.requisition_line_id

Line 7807: , PO_REQUISITION_LINES_ALL CHILD_LINE

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
7810: AND PARENT_DIST.requisition_line_id = PARENT_LINE.requisition_line_id
7811: AND MAIN_REQ.distribution_num = PARENT_DIST.distribution_num