DBA Data[Home] [Help]

APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 221: jai_po_line_locations jpll

217: AND po_distribution_id IN
218: (SELECT pda.po_distribution_id
219: FROM po_line_locations_all pll,
220: po_distributions_all pda,
221: jai_po_line_locations jpll
222: WHERE pll.line_location_id = jpll.line_location_id
223: AND pll.line_location_id = pda.line_location_id
224: AND pll.ship_to_organization_id = pn_organization_id)
225: UNION

Line 307: jai_po_line_locations jpll

303: AND (EXISTS
304: (SELECT 1
305: FROM po_line_locations_all pll,
306: po_distributions_all pda,
307: jai_po_line_locations jpll
308: WHERE pll.line_location_id = jpll.line_location_id
309: AND pll.line_location_id = pda.line_location_id
310: AND pll.ship_to_organization_id =pn_organization_id /* commented below and added pn_organization_id for bug 15862236 */
311: --nvl(pn_organization_id, pll.ship_to_organization_id)