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 486: xla_ae_lines xla_line,

482: FROM zx_rep_trx_detail_t zx_dtl,
483: xla_transaction_entities xla_ent,
484: xla_events xla_event,
485: xla_ae_headers xla_head,
486: xla_ae_lines xla_line,
487: xla_acct_class_assgns acs,
488: xla_assignment_defns_b asd,
489: xla_distribution_links xla_dist
490: WHERE zx_dtl.request_id = c_request_id

Line 1313: xla_ae_lines ael

1309: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1310: ael.code_combination_id
1311: FROM zx_rec_nrec_dist zx_dist,
1312: xla_distribution_links lnk,
1313: xla_ae_lines ael
1314: WHERE zx_dist.trx_id = c_trx_id
1315: AND zx_dist.APPLICATION_ID = c_application_id
1316: AND zx_dist.entity_code = c_entity_code
1317: AND zx_dist.event_class_Code = c_event_class_code

Line 1341: xla_ae_lines ael

1337: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1338: ael.code_combination_id
1339: FROM zx_rec_nrec_dist zx_dist,
1340: xla_distribution_links lnk,
1341: xla_ae_lines ael
1342: WHERE zx_dist.trx_id = c_trx_id
1343: AND zx_dist.APPLICATION_ID = c_application_id
1344: AND zx_dist.entity_code = c_entity_code
1345: AND zx_dist.event_class_Code = c_event_class_code

Line 1374: xla_ae_lines ael

1370: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1371: ael.code_combination_id
1372: FROM zx_rec_nrec_dist zx_dist,
1373: xla_distribution_links lnk,
1374: xla_ae_lines ael
1375: WHERE zx_dist.trx_id = c_trx_id
1376: AND zx_dist.APPLICATION_ID = c_application_id
1377: AND zx_dist.entity_code = c_entity_code
1378: AND zx_dist.event_class_Code = c_event_class_code

Line 1407: xla_ae_lines ael

1403: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) index(lnk XLA_DISTRIBUTION_LINKS_N1) */
1404: ael.code_combination_id
1405: FROM zx_rec_nrec_dist zx_dist,
1406: xla_distribution_links lnk,
1407: xla_ae_lines ael
1408: WHERE zx_dist.trx_id = c_trx_id
1409: AND zx_dist.APPLICATION_ID = c_application_id
1410: AND zx_dist.entity_code = c_entity_code
1411: AND zx_dist.event_class_Code = c_event_class_code

Line 1436: xla_ae_lines ael

1432: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) */
1433: ael.code_combination_id
1434: FROM zx_rec_nrec_dist zx_dist,
1435: xla_distribution_links lnk,
1436: xla_ae_lines ael
1437: WHERE zx_dist.trx_id = c_trx_id
1438: AND zx_dist.APPLICATION_ID = c_application_id
1439: AND zx_dist.entity_code = c_entity_code
1440: AND zx_dist.event_class_Code = c_event_class_code

Line 1465: xla_ae_lines ael

1461: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) */
1462: ael.code_combination_id
1463: FROM zx_rec_nrec_dist zx_dist,
1464: xla_distribution_links lnk,
1465: xla_ae_lines ael
1466: WHERE zx_dist.trx_id = c_trx_id
1467: AND zx_dist.APPLICATION_ID = c_application_id
1468: AND zx_dist.entity_code = c_entity_code
1469: AND zx_dist.event_class_Code = c_event_class_code

Line 1498: xla_ae_lines ael

1494: SELECT /*+ FIRST_ROWS(1) leading(zx_dist,lnk) */
1495: ael.code_combination_id
1496: FROM zx_rec_nrec_dist zx_dist,
1497: xla_distribution_links lnk,
1498: xla_ae_lines ael
1499: WHERE zx_dist.trx_id = c_trx_id
1500: AND zx_dist.APPLICATION_ID = c_application_id
1501: AND zx_dist.entity_code = c_entity_code
1502: AND zx_dist.event_class_Code = c_event_class_code

Line 2168: xla_ae_lines ael

2164: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2165: FROM zx_rec_nrec_dist zx_dist,
2166: xla_distribution_links lnk,
2167: xla_ae_headers aeh,
2168: xla_ae_lines ael
2169: WHERE zx_dist.trx_id = c_trx_id
2170: AND zx_dist.APPLICATION_ID = c_application_id
2171: AND zx_dist.entity_code = c_entity_code
2172: AND zx_dist.event_class_Code = c_event_class_code

Line 2200: xla_ae_lines ael

2196: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2197: FROM zx_rec_nrec_dist zx_dist,
2198: xla_distribution_links lnk,
2199: xla_ae_headers aeh,
2200: xla_ae_lines ael
2201: WHERE zx_dist.trx_id = c_trx_id
2202: AND zx_dist.APPLICATION_ID = c_application_id
2203: AND zx_dist.entity_code = c_entity_code
2204: AND zx_dist.event_class_Code = c_event_class_code

Line 2234: xla_ae_lines ael

2230: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2231: FROM zx_rec_nrec_dist zx_dist,
2232: xla_distribution_links lnk,
2233: xla_ae_headers aeh,
2234: xla_ae_lines ael
2235: WHERE zx_dist.trx_id = c_trx_id
2236: AND zx_dist.APPLICATION_ID = c_application_id
2237: AND zx_dist.entity_code = c_entity_code
2238: AND zx_dist.event_class_Code = c_event_class_code

Line 2267: xla_ae_lines ael

2263: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
2264: FROM zx_rec_nrec_dist zx_dist,
2265: xla_distribution_links lnk,
2266: xla_ae_headers aeh,
2267: xla_ae_lines ael
2268: WHERE zx_dist.trx_id = c_trx_id
2269: AND zx_dist.APPLICATION_ID = c_application_id
2270: AND zx_dist.entity_code = c_entity_code
2271: AND zx_dist.event_class_Code = c_event_class_code

Line 2297: xla_ae_lines ael

2293: SELECT SUM( nvl(lnk.UNROUNDED_ENTERED_DR,0) - (nvl(lnk.UNROUNDED_ENTERED_CR,0) )) ,
2294: SUM( nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0) ))
2295: FROM zx_rec_nrec_dist zx_dist,
2296: xla_distribution_links lnk,
2297: xla_ae_lines ael
2298: WHERE zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
2299: AND lnk.application_id = 200
2300: AND lnk.source_distribution_type in ('AP_INV_DIST','AP_PREPAY')
2301: AND lnk.tax_rec_nrec_dist_ref_id = zx_dist.rec_nrec_tax_dist_id

Line 2322: xla_ae_lines ael

2318: (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT)))),
2319: (nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))))
2320: FROM zx_rec_nrec_dist zx_dist,
2321: xla_distribution_links lnk,
2322: xla_ae_lines ael
2323: WHERE zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
2324: AND lnk.application_id = 200
2325: AND lnk.source_distribution_type = 'AP_INV_DIST'
2326: AND lnk.source_distribution_id_num_1 = zx_dist.trx_line_dist_id

Line 2341: xla_ae_lines ael

2337: SELECT SUM( (nvl(lnk.UNROUNDED_ENTERED_DR,0) - nvl(lnk.UNROUNDED_ENTERED_CR,0))),
2338: SUM( (nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)))
2339: FROM zx_rec_nrec_dist zx_dist,
2340: xla_distribution_links lnk,
2341: xla_ae_lines ael
2342: WHERE zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
2343: AND lnk.application_id = 200
2344: AND lnk.source_distribution_type = 'AP_INV_DIST'
2345: AND lnk.source_distribution_id_num_1 = zx_dist.trx_line_dist_id

Line 2379: xla_ae_lines ael

2375: -- (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT))))
2376: FROM zx_rec_nrec_dist zx_dist,
2377: xla_distribution_links lnk,
2378: xla_ae_headers aeh,
2379: xla_ae_lines ael
2380: WHERE zx_dist.trx_id = c_trx_id
2381: AND zx_dist.APPLICATION_ID = c_application_id
2382: AND zx_dist.entity_code = c_entity_code
2383: AND zx_dist.event_class_Code = c_event_class_code

Line 2422: xla_ae_lines ael,

2418: (abs(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - (nvl(lnk.UNROUNDED_ACCOUNTED_CR,0)))*
2419: (decode(sign(zx_dist.TRX_LINE_DIST_AMT),0,1,sign(zx_dist.TRX_LINE_DIST_AMT)))),
2420: (nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))))
2421: FROM zx_rec_nrec_dist zx_dist,
2422: xla_ae_lines ael,
2423: xla_distribution_links lnk
2424: WHERE zx_dist.trx_id = c_trx_id
2425: AND zx_dist.APPLICATION_ID = c_application_id
2426: AND zx_dist.entity_code = c_entity_code

Line 2456: xla_ae_lines ael

2452: SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2453: FROM ap_invoice_distributions_all ap_dist,
2454: xla_distribution_links lnk,
2455: xla_ae_headers aeh,
2456: xla_ae_lines ael
2457: WHERE ap_dist.invoice_id = c_trx_id
2458: AND ap_dist.invoice_line_number = c_trx_line_id
2459: AND ap_dist.invoice_distribution_id = c_trx_line_dist_id
2460: AND lnk.application_id = 200

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

2754: -- we already have trx_id as input parameter which can be used to join to
2755: -- ap_invoice_distributions or ap_invoice_payments. Why do we need the subquery?
2756: -- it seems to be unncessary if we put the same conditions in the main query. Also
2757: -- there a re no indexes based on xal.Upg_Tax_Reference_ID2/3 whihc causes FTS
2758: -- on xla_ae_lines. Need to get this query reviewed by AP team and log a bug
2759: -- against XLA team for indexes.
2760:
2761: SELECT /*+ leading (aid,aip) */
2762: xal.entered_dr - xal.entered_cr ,

Line 2770: xla_ae_lines xal

2766: FROM ap_invoice_distributions_all aid,
2767: -- ap_invoices_all ai,
2768: ap_invoice_payments_all aip,
2769: ap_payment_history_all aph,
2770: xla_ae_lines xal
2771: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2772: AND aid.line_type_lookup_code = 'ITEM'
2773: AND aip.invoice_id = aid.invoice_id
2774: -- AND aid.distribution_line_number

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

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

Line 2876: xla_ae_lines xal

2872: FROM ap_invoice_distributions_all aid,
2873: -- ap_invoices_all ai,
2874: ap_invoice_payments_all aip,
2875: ap_payment_history_all aph,
2876: xla_ae_lines xal
2877: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2878: AND aid.line_type_lookup_code = 'TAX'
2879: AND aip.invoice_id = aid.invoice_id
2880: -- AND aid.distribution_line_number

Line 2919: xla_ae_lines xal

2915: FROM ap_invoice_distributions_all aid,
2916: -- ap_invoices_all ai,
2917: ap_invoice_payments_all aip,
2918: ap_payment_history_all aph,
2919: xla_ae_lines xal
2920: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2921: AND aid.invoice_distribution_id = p_trx_line_id
2922: AND aip.invoice_id = aid.invoice_id
2923: AND xal.Upg_Tax_Reference_ID3 = aip.invoice_payment_id

Line 2958: xla_ae_lines xal

2954: FROM ap_invoice_distributions_all aid,
2955: -- ap_invoices_all ai,
2956: ap_invoice_payments_all aip,
2957: ap_payment_history_all aph,
2958: xla_ae_lines xal
2959: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2960: AND aid.invoice_distribution_id = p_tax_line_id
2961: AND aip.invoice_id = aid.invoice_id
2962: AND xal.Upg_Tax_Reference_ID3 = aip.invoice_payment_id

Line 3000: xla_ae_lines xal

2996: FROM ap_invoice_distributions_all aid,
2997: -- ap_invoices_all ai,
2998: ap_invoice_payments_all aip,
2999: ap_payment_history_all aph,
3000: xla_ae_lines xal
3001: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
3002: AND aid.invoice_distribution_id = p_trx_line_dist_id
3003: AND aip.invoice_id = aid.invoice_id
3004: AND xal.Upg_Tax_Reference_ID3 = aip.invoice_payment_id

Line 3056: xla_ae_lines xal

3052: FROM ap_invoice_distributions_all aid,
3053: -- ap_invoices_all ai,
3054: ap_invoice_payments_all aip,
3055: ap_payment_history_all aph,
3056: xla_ae_lines xal
3057: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
3058: -- AND aid.invoice_distribution_id = p_tax_line_id
3059: AND aid.detail_tax_dist_id = p_dist_id
3060: AND aip.invoice_id = aid.invoice_id