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.JG_ZZ_AR_AUTO_INVOICE dependencies on RA_INTERFACE_LINES_ALL

Line 783: TYPE bs_name IS TABLE OF ra_interface_lines_all.batch_source_name%Type;

779: AND l.interface_status IS NULL
780: AND l.batch_source_name = p_bs_name
781: AND l.org_id = p_org_id;
782:
783: TYPE bs_name IS TABLE OF ra_interface_lines_all.batch_source_name%Type;
784: TYPE bs_org_id IS TABLE OF ra_interface_lines_all.org_id%Type;
785:
786: batch_source_name bs_name;
787: org_id bs_org_id;

Line 784: TYPE bs_org_id IS TABLE OF ra_interface_lines_all.org_id%Type;

780: AND l.batch_source_name = p_bs_name
781: AND l.org_id = p_org_id;
782:
783: TYPE bs_name IS TABLE OF ra_interface_lines_all.batch_source_name%Type;
784: TYPE bs_org_id IS TABLE OF ra_interface_lines_all.org_id%Type;
785:
786: batch_source_name bs_name;
787: org_id bs_org_id;
788:

Line 848: UPDATE ra_interface_lines_all

844: IF (C_Trx_Interface_Rec.Trx_Date < trunc(SYSDATE) AND
845: C_Trx_Interface_Rec.Trx_Date < l_max_trx_date) OR
846: C_Trx_Interface_Rec.Trx_Date > trunc(SYSDATE) THEN
847:
848: UPDATE ra_interface_lines_all
849: SET Trx_Date = trunc(SYSDATE)
850: WHERE interface_line_id = C_Trx_Interface_Rec.interface_line_id
851: AND org_id = org_id(i);
852: