DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 588: FROM ap_invoice_distributions_all apd,

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

Line 596: FROM ap_invoice_distributions_all

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 =
595: (SELECT MIN(distribution_line_number)
596: FROM ap_invoice_distributions_all
597: WHERE invoice_id = p_ap_invoice_id);
598:
599: IF l_outsourced_assembly = 1
600: THEN