DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_LINES_ALL

Line 3605: FROM po_lines_all

3601: order_type_lookup_code,
3602: item_id,
3603: job_id,
3604: po_header_id --vegajula bugno:9531925
3605: FROM po_lines_all
3606: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3607: AND NOT EXISTS (SELECT 1
3608: FROM po_lines_draft_all
3609: WHERE po_line_id = x_lines.po_line_id_tbl(i)

Line 4278: FROM po_lines_all

4274: WHERE po_line_id = txn_lines.po_line_id
4275: AND shipment_type = 'BLANKET')
4276: OR
4277: EXISTS (SELECT 1
4278: FROM po_lines_all
4279: WHERE from_line_id = txn_lines.po_line_id)
4280: );
4281:
4282: DELETE FROM po_session_gt

Line 9502: FROM po_lines_all pli

9498: FROM dual;
9499:
9500: UPDATE po_session_gt psg
9501: SET psg.num3 = ( SELECT PLI.po_line_id
9502: FROM po_lines_all pli
9503: WHERE PLI.po_header_id = psg.num2
9504: AND PLI.line_num_display = psg.char1
9505: )
9506: WHERE psg.num2 IS NOT null