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 2052: , PO_REQUISITION_LINES_ALL PRL

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

Line 7408: , PO_REQUISITION_LINES_ALL PARENT_LINE

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

Line 7409: , PO_REQUISITION_LINES_ALL CHILD_LINE

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
7412: AND PARENT_DIST.requisition_line_id = PARENT_LINE.requisition_line_id
7413: )