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_DISTRIBUTION_LINKS

Line 439: xla_distribution_links xla_dist

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
440: WHERE zx_dtl.request_id = c_request_id
441: AND zx_dtl.extract_source_ledger = 'AP'
442: AND zx_dtl.posted_flag = 'A'
443: AND zx_dtl.trx_id = nvl(xla_ent.source_id_int_1,-99) -- Accounting Joins

Line 1163: xla_distribution_links lnk,

1159: c_ae_header_id number) IS
1160: SELECT
1161: ael.code_combination_id
1162: FROM zx_rec_nrec_dist zx_dist,
1163: xla_distribution_links lnk,
1164: xla_ae_lines ael
1165: WHERE zx_dist.trx_id = c_trx_id
1166: AND zx_dist.APPLICATION_ID = c_application_id
1167: AND zx_dist.entity_code = c_entity_code

Line 1193: xla_distribution_links lnk,

1189: c_ae_header_id NUMBER) IS
1190: SELECT
1191: ael.code_combination_id
1192: FROM zx_rec_nrec_dist zx_dist,
1193: xla_distribution_links lnk,
1194: xla_ae_lines ael
1195: WHERE zx_dist.trx_id = c_trx_id
1196: AND zx_dist.APPLICATION_ID = c_application_id
1197: AND zx_dist.entity_code = c_entity_code

Line 1225: xla_distribution_links lnk,

1221: c_ae_header_id NUMBER) IS
1222: SELECT
1223: ael.code_combination_id
1224: FROM zx_rec_nrec_dist zx_dist,
1225: xla_distribution_links lnk,
1226: xla_ae_lines ael
1227: WHERE zx_dist.trx_id = c_trx_id
1228: AND zx_dist.APPLICATION_ID = c_application_id
1229: AND zx_dist.entity_code = c_entity_code

Line 1255: xla_distribution_links lnk,

1251: c_ae_header_id number) IS
1252: SELECT
1253: ael.code_combination_id
1254: FROM zx_rec_nrec_dist zx_dist,
1255: xla_distribution_links lnk,
1256: xla_ae_lines ael
1257: WHERE zx_dist.trx_id = c_trx_id
1258: AND zx_dist.APPLICATION_ID = c_application_id
1259: AND zx_dist.entity_code = c_entity_code

Line 1285: xla_distribution_links lnk,

1281: c_ae_header_id number) IS
1282: SELECT
1283: ael.code_combination_id
1284: FROM zx_rec_nrec_dist zx_dist,
1285: xla_distribution_links lnk,
1286: xla_ae_lines ael
1287: WHERE zx_dist.trx_id = c_trx_id
1288: AND zx_dist.APPLICATION_ID = c_application_id
1289: AND zx_dist.entity_code = c_entity_code

Line 1318: xla_distribution_links lnk,

1314: c_ae_header_id number) IS
1315: SELECT
1316: ael.code_combination_id
1317: FROM zx_rec_nrec_dist zx_dist,
1318: xla_distribution_links lnk,
1319: xla_ae_lines ael
1320: WHERE zx_dist.trx_id = c_trx_id
1321: AND zx_dist.APPLICATION_ID = c_application_id
1322: AND zx_dist.entity_code = c_entity_code

Line 1906: xla_distribution_links lnk,

1902: c_event_id NUMBER,
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

Line 1938: xla_distribution_links lnk,

1934: c_event_id NUMBER,
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

Line 1972: xla_distribution_links lnk,

1968: c_event_id NUMBER,
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

Line 2005: xla_distribution_links lnk,

2001: c_event_id NUMBER,
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

Line 2052: xla_distribution_links lnk,

2048: -- sum(nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)) - SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0)) --Bug 5393051
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

Line 2092: xla_distribution_links lnk,

2088: (decode(sign(zx_dist.taxable_amt),0,1,sign(zx_dist.taxable_amt)))),
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

Line 2132: xla_distribution_links lnk

2128: SUM( abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))) *
2129: (decode(sign(zx_dist.taxable_amt),0,1,sign(zx_dist.taxable_amt))))
2130: FROM zx_rec_nrec_dist zx_dist,
2131: xla_ae_lines ael,
2132: xla_distribution_links lnk
2133: WHERE zx_dist.trx_id = c_trx_id
2134: AND zx_dist.APPLICATION_ID = c_application_id
2135: AND zx_dist.entity_code = c_entity_code
2136: AND zx_dist.event_class_Code = c_event_class_code