eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 219: FROM po_line_locations_all pll,

215: FROM ap_invoice_distributions_all
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

Line 305: FROM po_line_locations_all pll,

301: cp_till_date)) */ /* commented and added below condition for bug 15862236 */
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

Line 1419: FROM po_line_locations_all po, ap_invoice_lines_all ap

1415: AND parent_invoice_line_number IS NULL;
1416:
1417: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
1418: SELECT po.ship_to_organization_id, po.ship_to_location_id
1419: FROM po_line_locations_all po, ap_invoice_lines_all ap
1420: WHERE po.line_location_id = ap.po_line_location_id
1421: AND ap.invoice_id = p_invoice_id
1422: AND ap.line_number = pn_line_number;
1423: