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_XLA_UPGRADE dependencies on PA_PRIM_REP_LEGER_TMP

Line 1605: INSERT INTO PA_PRIM_REP_LEGER_tmp (prim_ledger_id,

1601:
1602:
1603:
1604: /*Bug 49435531 */
1605: INSERT INTO PA_PRIM_REP_LEGER_tmp (prim_ledger_id,
1606: denorm_ledger_id,
1607: period_name,
1608: batch_id)
1609: SELECT distinct per1.ledger_id,

Line 1632: INSERT INTO PA_PRIM_REP_LEGER_tmp (prim_ledger_id,

1628: )
1629: ));
1630:
1631:
1632: INSERT INTO PA_PRIM_REP_LEGER_tmp (prim_ledger_id,
1633: denorm_ledger_id,
1634: period_name,
1635: batch_id)
1636: SELECT distinct mc.reporting_set_of_books_id,--per.prim_ledger_id Bug 12335611

Line 1640: FROM PA_PRIM_REP_LEGER_tmp per,

1636: SELECT distinct mc.reporting_set_of_books_id,--per.prim_ledger_id Bug 12335611
1637: mc.reporting_set_of_books_id,
1638: per.period_name,
1639: p_batch_id
1640: FROM PA_PRIM_REP_LEGER_tmp per,
1641: gl_mc_reporting_options_11i mc,
1642: pa_implementations_all imp
1643: WHERE per.prim_ledger_id = mc.primary_set_of_books_id
1644: AND mc.application_id in( 275,8721)

Line 1657: PA_PRIM_REP_LEGER_tmp per

1653: BEGIN
1654: Select min(je_header_id), max(je_header_id)
1655: into l_jeh_min_id, l_jeh_max_id
1656: from gl_je_headers hd,
1657: PA_PRIM_REP_LEGER_tmp per
1658: where hd.LEDGER_ID = per.denorm_ledger_id
1659: and hd.PERIOD_NAME = per.PERIOD_NAME
1660: and hd.je_source = 'Project Accounting'
1661: and per.batch_id = p_batch_id;