APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1241: FROM po_line_locations_draft_all

1237: SET (amount, quantity,secondary_quantity) =
1238: (select sum(Decode(Nvl(payment_type,'DELIVERY'),'RATE',Nvl(quantity,0)*Nvl(price_override,0),amount)),
1239: sum(Decode(Nvl(payment_type,'DELIVERY'),'RATE',NULL,quantity)),
1240: sum(secondary_quantity)
1241: FROM po_line_locations_draft_all
1242: WHERE po_line_id = draft_lines.po_line_id
1243: AND draft_id = draft_lines.draft_id
1244: AND (payment_type IS NULL OR payment_type NOT IN ('ADVANCE','DELIVERY')))
1245: -- PDOI for Complex PO Project