DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 309: FROM po_line_locations_all poll

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

Line 590: po_line_locations_all plla

586: SELECT DISTINCT NVL(plla.outsourced_assembly, 2)
587: INTO l_outsourced_assembly
588: FROM ap_invoice_distributions_all apd,
589: po_distributions_all pda,
590: po_line_locations_all plla
591: WHERE apd.po_distribution_id = pda.po_distribution_id
592: AND pda.line_location_id = plla.line_location_id
593: AND apd.invoice_id = p_ap_invoice_id
594: AND apd.distribution_line_number =