DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 570: FROM ap_invoice_distributions_all apd,

566: -- flag checked, and those with the flag unchecked.
567:
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

Line 578: FROM ap_invoice_distributions_all

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 =
577: (SELECT MIN(distribution_line_number)
578: FROM ap_invoice_distributions_all
579: WHERE invoice_id = p_ap_invoice_id);
580:
581: IF l_outsourced_assembly = 1
582: THEN