APPS.PO_VAL_LINES2 dependencies on PO_LINES_DRAFT_ALL

Line 2300: FROM po_lines_draft_all PLD

2296: FROM po_lines_all pln
2297: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2298: AND pln.line_num = p_line_num_tbl(i)
2299: AND NOT EXISTS (SELECT 'Y'
2300: FROM po_lines_draft_all PLD
2301: WHERE PLN.po_line_id = PLD.po_line_id
2302: AND PLD.draft_id = p_draft_id_tbl(i)))
2303: OR
2304: EXISTS (SELECT 'Y'

Line 2305: FROM po_lines_draft_all PLD

2301: WHERE PLN.po_line_id = PLD.po_line_id
2302: AND PLD.draft_id = p_draft_id_tbl(i)))
2303: OR
2304: EXISTS (SELECT 'Y'
2305: FROM po_lines_draft_all PLD
2306: WHERE PLD.draft_id = p_draft_id_tbl(i)
2307: AND PLD.po_header_id = p_po_header_id_tbl(i)
2308: AND PLD.line_num = p_line_num_tbl(i)
2309: AND NVL(PLD.delete_flag, 'N') <> 'Y'));

Line 3631: FROM po_lines_draft_all pld

3627: FROM po_lines_all pol
3628: WHERE p_po_line_id_tbl(i) = pol.po_line_id
3629: AND p_category_id_tbl(i) <> pol.category_id)
3630: OR EXISTS(SELECT 1
3631: FROM po_lines_draft_all pld
3632: WHERE p_po_line_id_tbl(i) = pld.po_line_id
3633: AND p_category_id_tbl(i) <> pld.category_id));
3634:
3635: IF (SQL%ROWCOUNT > 0) THEN

Line 3757: FROM po_lines_draft_all POL

3753: 'PO_PDOI_SVC_NO_PRICE',
3754: 'UNIT_PRICE',
3755: p_unit_price_tbl(i),
3756: PO_VAL_CONSTANTS.c_unit_price_null
3757: FROM po_lines_draft_all POL
3758: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3759: AND POL.draft_id = p_draft_id_tbl(i)
3760: AND POL.order_type_lookup_code = 'FIXED PRICE'
3761: AND p_unit_price_tbl(i) IS NOT NULL;

Line 3882: FROM po_lines_draft_all POL

3878: 'PO_PDOI_SVC_BLKT_NO_AMT',
3879: 'AMOUNT',
3880: p_amount_tbl(i),
3881: PO_VAL_CONSTANTS.c_amount_blanket
3882: FROM po_lines_draft_all POL
3883: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3884: AND POL.draft_id = p_draft_id_tbl(i)
3885: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3886: AND p_amount_tbl(i) IS NOT NULL;