DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 307: FROM po_line_locations_all poll

303: -- Selecting the shikyu_osa_item_flag of PO Line
304: -- with the passed in PO Line ID
305: SELECT nvl(outsourced_assembly, 2)
306: INTO l_outsourced_assembly
307: FROM po_line_locations_all poll
308: WHERE poll.line_location_id = p_po_shipment_id;
309:
310: IF g_fnd_debug = 'Y' AND
311: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 572: po_line_locations_all plla

568: SELECT DISTINCT NVL(plla.outsourced_assembly, 2)
569: INTO l_outsourced_assembly
570: FROM ap_invoice_distributions_all apd,
571: po_distributions_all pda,
572: po_line_locations_all plla
573: WHERE apd.po_distribution_id = pda.po_distribution_id
574: AND pda.line_location_id = plla.line_location_id
575: AND apd.invoice_id = p_ap_invoice_id
576: AND apd.distribution_line_number =