APPS.PO_VAL_LINES2 dependencies on PO_LINES_DRAFT_ALL

Line 2361: FROM po_lines_draft_all PLD

2357: FROM po_lines_all pln
2358: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2359: AND pln.line_num = p_line_num_tbl(i)
2360: AND NOT EXISTS (SELECT 'Y'
2361: FROM po_lines_draft_all PLD
2362: WHERE PLN.po_line_id = PLD.po_line_id
2363: AND PLD.draft_id = p_draft_id_tbl(i)))
2364: OR
2365: EXISTS (SELECT 'Y'

Line 2366: FROM po_lines_draft_all PLD

2362: WHERE PLN.po_line_id = PLD.po_line_id
2363: AND PLD.draft_id = p_draft_id_tbl(i)))
2364: OR
2365: EXISTS (SELECT 'Y'
2366: FROM po_lines_draft_all PLD
2367: WHERE PLD.draft_id = p_draft_id_tbl(i)
2368: AND PLD.po_header_id = p_po_header_id_tbl(i)
2369: AND PLD.line_num = p_line_num_tbl(i)
2370: AND NVL(PLD.delete_flag, 'N') <> 'Y'));

Line 3695: FROM po_lines_draft_all pld

3691: FROM po_lines_all pol
3692: WHERE p_po_line_id_tbl(i) = pol.po_line_id
3693: AND p_category_id_tbl(i) <> pol.category_id)
3694: OR EXISTS(SELECT 1
3695: FROM po_lines_draft_all pld
3696: WHERE p_po_line_id_tbl(i) = pld.po_line_id
3697: AND p_category_id_tbl(i) <> pld.category_id));
3698:
3699: IF (SQL%ROWCOUNT > 0) THEN

Line 3821: FROM po_lines_draft_all POL

3817: 'PO_PDOI_SVC_NO_PRICE',
3818: 'UNIT_PRICE',
3819: p_unit_price_tbl(i),
3820: PO_VAL_CONSTANTS.c_unit_price_null
3821: FROM po_lines_draft_all POL
3822: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3823: AND POL.draft_id = p_draft_id_tbl(i)
3824: AND POL.order_type_lookup_code = 'FIXED PRICE'
3825: AND p_unit_price_tbl(i) IS NOT NULL;

Line 3978: FROM po_lines_draft_all POL

3974: 'PO_PDOI_SVC_BLKT_NO_AMT',
3975: 'AMOUNT',
3976: p_amount_tbl(i),
3977: PO_VAL_CONSTANTS.c_amount_blanket
3978: FROM po_lines_draft_all POL
3979: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3980: AND POL.draft_id = p_draft_id_tbl(i)
3981: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3982: AND p_amount_tbl(i) IS NOT NULL;