DBA Data[Home] [Help]

APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 220: po_distributions_all pda,

216: WHERE org_id = p_org_id
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)

Line 306: po_distributions_all pda,

302: AND prepay.accounting_date BETWEEN cp_start_date AND cp_till_date
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 */