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.PA_BILL_REV_XLA_UPGRADE dependencies on PA_REV_AE_LINES_TMP

Line 546: INTO PA_REV_AE_LINES_TMP

542: and hr.org_information_context = 'Operating Unit Information';
543:
544: INSERT ALL
545: WHEN 1 = 1 THEN
546: INTO PA_REV_AE_LINES_TMP
547: (ae_header_id,
548: ae_line_num,
549: gl_batch_name,
550: code_combination_id,

Line 814: PA_REV_AE_LINES_TMP tmp

810:
811: UPDATE XLA_AE_LINES lin
812: SET lin.gl_sl_link_id = (SELECT gl_sl_link_id
813: FROM GL_IMPORT_REFERENCES imp,
814: PA_REV_AE_LINES_TMP tmp
815: WHERE imp.reference_6 = tmp.gl_batch_name
816: AND imp.reference_2 = tmp.code_combination_id
817: AND imp.reference_3 = tmp.dist_type
818: AND lin.ae_header_id = tmp.ae_header_id

Line 823: FROM PA_REV_AE_LINES_TMP tmp1

819: AND lin.ae_line_num = tmp.ae_line_num
820: AND imp.gl_sl_link_id is not null /*Bug 5168431*/
821: AND rownum =1)
822: WHERE EXISTS ( SELECT 1
823: FROM PA_REV_AE_LINES_TMP tmp1
824: WHERE lin.ae_header_id = tmp1.ae_header_id
825: AND lin.ae_line_num = tmp1.ae_line_num)
826: AND lin.application_id = 275
827: AND lin.gl_sl_link_id is null

Line 1240: INTO PA_REV_AE_LINES_TMP

1236: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
1237:
1238: INSERT ALL
1239: WHEN 1 = 1 THEN
1240: INTO PA_REV_AE_LINES_TMP
1241: (ae_header_id,
1242: ae_line_num,
1243: gl_batch_name,
1244: code_combination_id,

Line 1546: PA_REV_AE_LINES_TMP tmp

1542:
1543: UPDATE XLA_AE_LINES lin
1544: SET lin.gl_sl_link_id = (select gl_sl_link_id
1545: FROM GL_IMPORT_REFERENCES imp,
1546: PA_REV_AE_LINES_TMP tmp
1547: WHERE imp.reference_6 = tmp.gl_batch_name
1548: AND imp.reference_2 = tmp.code_combination_id
1549: AND imp.reference_3 = tmp.dist_type
1550: AND lin.ae_header_id = tmp.ae_header_id

Line 1555: FROM PA_REV_AE_LINES_TMP tmp1

1551: AND lin.ae_line_num = tmp.ae_line_num
1552: AND imp.gl_sl_link_id is not null /*Bug 5168431*/
1553: AND rownum=1)
1554: WHERE EXISTS ( SELECT 1
1555: FROM PA_REV_AE_LINES_TMP tmp1
1556: WHERE lin.ae_header_id = tmp1.ae_header_id
1557: AND lin.ae_line_num = tmp1.ae_line_num)
1558: AND lin.application_id = 275
1559: AND lin.gl_sl_link_id is null