APPS.JMF_SHIKYU_PO_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 184: FROM po_line_locations_all poll

180: -- interface_header_id for reference_num, and interface line id for line_reference_num
181:
182: CURSOR c_po IS
183: SELECT poll.line_location_id
184: FROM po_line_locations_all poll
185: , po_headers_all poh
186: , po_lines_all pol
187: WHERE poll.po_header_id = poh.po_header_id
188: AND poll.po_line_id = pol.po_line_id

Line 253: FROM po_line_locations_all

249: SELECT
250: org_id
251: INTO
252: l_org_id
253: FROM po_line_locations_all
254: WHERE line_location_id = l_subcontract_orders_rec.subcontract_po_shipment_id;
255:
256: SELECT
257: user_defined_po_num_code

Line 347: -- To get the actual need_by_date from po_line_locations_all table

343: );
344: END IF;
345: END IF;
346:
347: -- To get the actual need_by_date from po_line_locations_all table
348: -- since the it might be changed after the intial creation of the
349: -- Subcontract PO
350:
351: SELECT NVL(need_by_date, promised_date)

Line 353: FROM po_line_locations_all

349: -- Subcontract PO
350:
351: SELECT NVL(need_by_date, promised_date)
352: INTO l_subcontract_orders_rec.need_by_date
353: FROM po_line_locations_all
354: WHERE line_location_id = l_subcontract_orders_rec.subcontract_po_shipment_id;
355:
356: IF g_log_enabled THEN
357: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 578: FROM po_line_locations_all;

574: -- To get the max line_location_id before calling submit_request
575: -- for better performance
576: SELECT max(line_location_id)
577: INTO l_max_line_location_id
578: FROM po_line_locations_all;
579:
580: l_request_id := FND_REQUEST.submit_request
581: ( application => 'PO'
582: , program => 'POXPOPDOI'

Line 689: (SELECT 1 FROM po_line_locations_all poll

685: SELECT segment1
686: INTO l_order_number
687: FROM po_headers_all poh
688: WHERE EXISTS
689: (SELECT 1 FROM po_line_locations_all poll
690: WHERE poll.line_location_id = l_subcontract_orders_rec.subcontract_po_shipment_id
691: AND poll.po_header_id = poh.po_header_id);
692:
693: SELECT segment1