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_LINES

Line 436: xla_ae_lines xla_line,

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
440: WHERE zx_dtl.request_id = c_request_id

Line 1164: xla_ae_lines ael

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
1168: AND zx_dist.event_class_Code = c_event_class_code

Line 1194: xla_ae_lines ael

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
1198: AND zx_dist.event_class_Code = c_event_class_code

Line 1226: xla_ae_lines ael

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
1230: AND zx_dist.event_class_Code = c_event_class_code

Line 1256: xla_ae_lines ael

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
1260: AND zx_dist.event_class_Code = c_event_class_code

Line 1286: xla_ae_lines ael

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
1290: AND zx_dist.event_class_Code = c_event_class_code

Line 1319: xla_ae_lines ael

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
1323: AND zx_dist.event_class_Code = c_event_class_code

Line 1908: xla_ae_lines ael

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
1912: AND zx_dist.event_class_Code = c_event_class_code

Line 1940: xla_ae_lines ael

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
1944: AND zx_dist.event_class_Code = c_event_class_code

Line 1974: xla_ae_lines ael

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
1978: AND zx_dist.event_class_Code = c_event_class_code

Line 2007: xla_ae_lines ael

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
2011: AND zx_dist.event_class_Code = c_event_class_code

Line 2054: xla_ae_lines ael

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
2058: AND zx_dist.event_class_Code = c_event_class_code

Line 2094: xla_ae_lines ael

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
2098: AND zx_dist.event_class_Code = c_event_class_code

Line 2131: xla_ae_lines ael,

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

Line 2371: -- on xla_ae_lines. Need to get this query reviewed by AP team and log a bug

2367: -- we already have trx_id as input parameter which can be used to join to
2368: -- ap_invoice_distributions or ap_invoice_payments. Why do we need the subquery?
2369: -- it seems to be unncessary if we put the same conditions in the main query. Also
2370: -- there a re no indexes based on xal.Upg_Tax_Reference_ID2/3 whihc causes FTS
2371: -- on xla_ae_lines. Need to get this query reviewed by AP team and log a bug
2372: -- against XLA team for indexes.
2373:
2374: SELECT xal.entered_dr - xal.entered_cr ,
2375: -- discount entered amount (replace this with new xla colum names)

Line 2382: xla_ae_lines xal

2378: FROM ap_invoice_distributions_all aid,
2379: -- ap_invoices_all ai,
2380: ap_invoice_payments_all aip,
2381: ap_payment_history_all aph,
2382: xla_ae_lines xal
2383: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2384: AND aid.invoice_id = aip.invoice_id
2385: AND aid.distribution_line_number
2386: IN (SELECT distribution_line_number

Line 2403: -- on xla_ae_lines. Need to get this query reviewed by AP team and log a bug

2399: -- we already have trx_id as input parameter which can be used to join to
2400: -- ap_invoice_distributions or ap_invoice_payments. Why do we need the subquery?
2401: -- it seems to be unncessary if we put the same conditions in the main query. Also
2402: -- there a re no indexes based on xal.Upg_Tax_Reference_ID2/3 whihc causes FTS
2403: -- on xla_ae_lines. Need to get this query reviewed by AP team and log a bug
2404: -- against XLA team for indexes.
2405:
2406: CURSOR tax_hdr_csr IS
2407: SELECT sum(aphd.amount), -- discount amount (entered)

Line 2435: xla_ae_lines xal

2431: FROM ap_invoice_distributions_all aid,
2432: -- ap_invoices_all ai,
2433: ap_invoice_payments_all aip,
2434: ap_payment_history_all aph,
2435: xla_ae_lines xal
2436: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2437: AND aid.invoice_id = aip.invoice_id
2438: AND aid.distribution_line_number
2439: IN (SELECT distribution_line_number

Line 2476: xla_ae_lines xal

2472: FROM ap_invoice_distributions_all aid,
2473: -- ap_invoices_all ai,
2474: ap_invoice_payments_all aip,
2475: ap_payment_history_all aph,
2476: xla_ae_lines xal
2477: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2478: AND aid.invoice_id = aip.invoice_id
2479: -- AND aid.distribution_line_number
2480: AND aid.invoice_distribution_id = p_trx_line_id

Line 2514: xla_ae_lines xal

2510: FROM ap_invoice_distributions_all aid,
2511: -- ap_invoices_all ai,
2512: ap_invoice_payments_all aip,
2513: ap_payment_history_all aph,
2514: xla_ae_lines xal
2515: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2516: AND aid.invoice_id = aip.invoice_id
2517: -- AND aid.distribution_line_number
2518: AND aid.invoice_distribution_id = p_tax_line_id

Line 2552: xla_ae_lines xal

2548: FROM ap_invoice_distributions_all aid,
2549: -- ap_invoices_all ai,
2550: ap_invoice_payments_all aip,
2551: ap_payment_history_all aph,
2552: xla_ae_lines xal
2553: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2554: AND aid.invoice_id = aip.invoice_id
2555: -- AND aid.distribution_line_number
2556: AND aid.invoice_distribution_id = p_trx_line_id

Line 2590: xla_ae_lines xal

2586: FROM ap_invoice_distributions_all aid,
2587: -- ap_invoices_all ai,
2588: ap_invoice_payments_all aip,
2589: ap_payment_history_all aph,
2590: xla_ae_lines xal
2591: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2592: AND aid.invoice_id = aip.invoice_id
2593: -- AND aid.distribution_line_number
2594: AND aid.invoice_distribution_id = p_tax_line_id