APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 1662: FROM po_line_locations_draft_all poll,

1658: CURSOR cur_ship_lines
1659: IS
1660: SELECT interface_line_id,
1661: line_location_id
1662: FROM po_line_locations_draft_all poll,
1663: (SELECT interface_line_id interface_line_id,
1664: po_line_id po_line_id,
1665: shipment_num shipment_num
1666: FROM (SELECT interface_line_id,

Line 2632: FROM po_line_locations_draft_all

2628: AND ea.classification_code = To_Char(pudat.template_id )
2629: AND ead.EXECUTION_METHOD = 'XPD'
2630: AND poh.po_header_id = po_autocreate_params.g_po_header_id
2631: AND pudat.template_id = (SELECT uda_template_id
2632: FROM po_line_locations_draft_all
2633: WHERE po_header_id = poh.po_header_id
2634: AND ROWNUM < 2) ;
2635: END IF;
2636:

Line 2739: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll

2735:
2736: CURSOR c_shipments
2737: IS
2738: SELECT pll.line_location_id
2739: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2740: WHERE
2741: --bug 13640946 commenting out the condition as template_id has been stamped in the drafts table before making thisa uda call.
2742: --pll.uda_template_id IS NULL AND
2743: PLI.interface_header_id = po_autocreate_params.g_interface_header_id