APPS.PO_CLM_COLS_SUB_CHECK dependencies on PO_LINES_MERGE_V

Line 1168: FROM PO_LINES_MERGE_V

1164: IF po_encumbrance_preprocessing.g_call_from_encumbrance <> 'Y' THEN
1165: BEGIN
1166: SELECT SUM(Nvl(QUANTITY,0))
1167: INTO l_line_base_qty
1168: FROM PO_LINES_MERGE_V
1169: WHERE PO_HEADER_ID = p_document_id
1170: AND FROM_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID
1171: AND FROM_LINE_ID = c_get_po_lines_rec.IDV_LINE_ID
1172: AND DRAFT_ID = -1

Line 1186: FROM PO_LINES_MERGE_V

1182: IF p_draft_id <> -1 THEN
1183: BEGIN
1184: SELECT SUM(Nvl(QUANTITY,0))
1185: INTO l_line_mod_qty
1186: FROM PO_LINES_MERGE_V
1187: WHERE PO_HEADER_ID = p_document_id
1188: AND FROM_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID
1189: AND FROM_LINE_ID = c_get_po_lines_rec.IDV_LINE_ID
1190: AND DRAFT_ID = p_draft_id

Line 2554: FROM po_lines_merge_v pol

2550: )
2551: )
2552: )
2553: INTO l_return_val
2554: FROM po_lines_merge_v pol
2555: WHERE pol.po_header_id = p_header_id
2556: AND pol.draft_id = p_draft_id
2557: AND (pol.from_header_id = p_idv_header_id OR
2558: pol.contract_id = p_idv_header_id

Line 2577: FROM po_lines_merge_v pol

2573: )
2574: )
2575: )
2576: INTO l_return_val
2577: FROM po_lines_merge_v pol
2578: WHERE pol.po_header_id = p_header_id
2579: AND pol.draft_id = p_draft_id
2580: AND pol.from_header_id = p_idv_header_id
2581: AND pol.FROM_LINE_ID = p_idv_line_id;