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.ZX_AP_POPULATE_PKG dependencies on XLA_AE_HEADERS

Line 435: xla_ae_headers xla_head,

431: zx_dtl.tax_type_code
432: FROM zx_rep_trx_detail_t zx_dtl,
433: xla_transaction_entities xla_ent,
434: xla_events xla_event,
435: xla_ae_headers xla_head,
436: xla_ae_lines xla_line,
437: xla_acct_class_assgns acs,
438: xla_assignment_defns_b asd,
439: xla_distribution_links xla_dist

Line 1907: xla_ae_headers aeh,

1903: c_ledger_id NUMBER) IS
1904: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1905: FROM zx_rec_nrec_dist zx_dist,
1906: xla_distribution_links lnk,
1907: xla_ae_headers aeh,
1908: xla_ae_lines ael
1909: WHERE zx_dist.trx_id = c_trx_id
1910: AND zx_dist.APPLICATION_ID = c_application_id
1911: AND zx_dist.entity_code = c_entity_code

Line 1939: xla_ae_headers aeh,

1935: c_ledger_id NUMBER) IS
1936: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1937: FROM zx_rec_nrec_dist zx_dist,
1938: xla_distribution_links lnk,
1939: xla_ae_headers aeh,
1940: xla_ae_lines ael
1941: WHERE zx_dist.trx_id = c_trx_id
1942: AND zx_dist.APPLICATION_ID = c_application_id
1943: AND zx_dist.entity_code = c_entity_code

Line 1973: xla_ae_headers aeh,

1969: c_ledger_id NUMBER) IS
1970: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1971: FROM zx_rec_nrec_dist zx_dist,
1972: xla_distribution_links lnk,
1973: xla_ae_headers aeh,
1974: xla_ae_lines ael
1975: WHERE zx_dist.trx_id = c_trx_id
1976: AND zx_dist.APPLICATION_ID = c_application_id
1977: AND zx_dist.entity_code = c_entity_code

Line 2006: xla_ae_headers aeh,

2002: c_ledger_id NUMBER) IS
2003: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2004: FROM zx_rec_nrec_dist zx_dist,
2005: xla_distribution_links lnk,
2006: xla_ae_headers aeh,
2007: xla_ae_lines ael
2008: WHERE zx_dist.trx_id = c_trx_id
2009: AND zx_dist.APPLICATION_ID = c_application_id
2010: AND zx_dist.entity_code = c_entity_code

Line 2053: xla_ae_headers aeh,

2049: Nvl(sum(decode(zx_dist.REVERSE_FLAG,'Y',lnk.UNROUNDED_ENTERED_CR * -1,lnk.UNROUNDED_ENTERED_DR)),0),
2050: Nvl(sum(decode(zx_dist.REVERSE_FLAG,'Y',lnk.UNROUNDED_ACCOUNTED_CR * -1,lnk.UNROUNDED_ACCOUNTED_DR)),0) */
2051: FROM zx_rec_nrec_dist zx_dist,
2052: xla_distribution_links lnk,
2053: xla_ae_headers aeh,
2054: xla_ae_lines ael
2055: WHERE zx_dist.trx_id = c_trx_id
2056: AND zx_dist.APPLICATION_ID = c_application_id
2057: AND zx_dist.entity_code = c_entity_code

Line 2093: xla_ae_headers aeh,

2089: SUM( abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))) *
2090: (decode(sign(zx_dist.taxable_amt),0,1,sign(zx_dist.taxable_amt))))
2091: FROM zx_rec_nrec_dist zx_dist,
2092: xla_distribution_links lnk,
2093: xla_ae_headers aeh,
2094: xla_ae_lines ael
2095: WHERE zx_dist.trx_id = c_trx_id
2096: AND zx_dist.APPLICATION_ID = c_application_id
2097: AND zx_dist.entity_code = c_entity_code