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.JA_CN_PS_FSG_XML_SUBMIT_PROG dependencies on RG_ROW_ORDERS

Line 236: FROM rg_row_orders ro, rg_reports rp

232: --ROW_ORDER_ID
233: BEGIN
234: SELECT ro.row_order_id
235: INTO ln_row_order_id
236: FROM rg_row_orders ro, rg_reports rp
237: WHERE rp.report_id = pn_balance_sheet_id
238: AND rp.row_order_id = ro.row_order_id(+);
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN

Line 369: FROM rg_row_orders ro, rg_reports rp

365: --ROW_ORDER_ID
366: BEGIN
367: SELECT ro.row_order_id
368: INTO ln_row_order_id
369: FROM rg_row_orders ro, rg_reports rp
370: WHERE rp.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
371: AND rp.row_order_id = ro.row_order_id(+);
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN

Line 501: FROM rg_row_orders ro, rg_reports rp

497: --ROW_ORDER_ID
498: BEGIN
499: SELECT ro.row_order_id
500: INTO ln_row_order_id
501: FROM rg_row_orders ro, rg_reports rp
502: WHERE rp.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
503: AND rp.row_order_id = ro.row_order_id(+);
504: EXCEPTION
505: WHEN NO_DATA_FOUND THEN