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_ACTG_POPULATE_PKG dependencies on XLA_AE_LINES

Line 554: xla_ae_lines ael

550: SELECT
551: ael.code_combination_id
552: FROM zx_rec_nrec_dist zx_dist,
553: xla_distribution_links lnk,
554: xla_ae_lines ael
555: WHERE zx_dist.trx_id = c_trx_id
556: AND lnk.application_id = 200
557: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
558: AND lnk.source_distribution_id_num_1 = zx_dist.trx_line_dist_id

Line 574: xla_ae_lines ael

570: SELECT
571: ael.code_combination_id
572: FROM zx_rec_nrec_dist zx_dist,
573: xla_distribution_links lnk,
574: xla_ae_lines ael
575: WHERE zx_dist.trx_id = c_trx_id
576: AND zx_dist.trx_line_id = c_trx_line_id
577: AND lnk.application_id = 200
578: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

Line 595: xla_ae_lines ael

591: SELECT
592: ael.code_combination_id
593: FROM zx_rec_nrec_dist zx_dist,
594: xla_distribution_links lnk,
595: xla_ae_lines ael
596: WHERE zx_dist.trx_id = c_trx_id
597: AND zx_dist.trx_line_id = c_trx_line_id
598: AND lnk.application_id = 200
599: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

Line 614: xla_ae_lines ael

610: SELECT
611: ael.code_combination_id
612: FROM zx_rec_nrec_dist zx_dist,
613: xla_distribution_links lnk,
614: xla_ae_lines ael
615: WHERE zx_dist.trx_id = c_trx_id
616: AND lnk.application_id = 200
617: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
618: AND lnk.tax_rec_nrec_dist_ref_id = zx_dist.rec_nrec_tax_dist_id

Line 631: xla_ae_lines ael

627: SELECT
628: ael.code_combination_id
629: FROM zx_rec_nrec_dist zx_dist,
630: xla_distribution_links lnk,
631: xla_ae_lines ael
632: WHERE zx_dist.trx_id = c_trx_id
633: AND zx_dist.tax_line_id = c_tax_line_id
634: AND lnk.application_id = 200
635: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

Line 653: xla_ae_lines ael

649: SELECT
650: ael.code_combination_id
651: FROM zx_rec_nrec_dist zx_dist,
652: xla_distribution_links lnk,
653: xla_ae_lines ael
654: WHERE zx_dist.trx_id = c_trx_id
655: AND zx_dist.tax_line_id = c_tax_line_id
656: AND zx_dist.REC_NREC_TAX_DIST_ID = c_tax_line_dist_id
657: AND lnk.application_id = 200

Line 982: xla_ae_lines ael

978: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
979: FROM zx_rec_nrec_dist zx_dist,
980: xla_distribution_links lnk,
981: xla_ae_headers aeh,
982: xla_ae_lines ael
983: WHERE zx_dist.trx_id = c_trx_id
984: AND lnk.application_id = 200
985: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
986: AND lnk.source_distribution_id_num_1 = zx_dist.trx_line_id

Line 1000: xla_ae_lines ael

996: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
997: FROM zx_rec_nrec_dist zx_dist,
998: xla_distribution_links lnk,
999: xla_ae_headers aeh,
1000: xla_ae_lines ael
1001: WHERE zx_dist.trx_id = c_trx_id
1002: AND lnk.application_id = 200
1003: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
1004: AND lnk.tax_rec_nrec_dist_ref_id = zx_dist.rec_nrec_tax_dist_id

Line 1020: xla_ae_lines ael

1016: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1017: FROM zx_rec_nrec_dist zx_dist,
1018: xla_distribution_links lnk,
1019: xla_ae_headers aeh,
1020: xla_ae_lines ael
1021: WHERE zx_dist.trx_id = c_trx_id
1022: AND zx_dist.trx_line_id = c_trx_line_id
1023: AND lnk.application_id = 200
1024: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

Line 1039: xla_ae_lines ael

1035: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1036: FROM zx_rec_nrec_dist zx_dist,
1037: xla_distribution_links lnk,
1038: xla_ae_headers aeh,
1039: xla_ae_lines ael
1040: WHERE zx_dist.trx_id = c_trx_id
1041: AND zx_dist.tax_line_id = c_tax_line_id
1042: AND lnk.application_id = 200
1043: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

Line 1062: xla_ae_lines ael

1058: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1059: FROM zx_rec_nrec_dist zx_dist,
1060: xla_distribution_links lnk,
1061: xla_ae_headers aeh,
1062: xla_ae_lines ael
1063: WHERE zx_dist.trx_id = c_trx_id
1064: AND zx_dist.tax_line_id = c_tax_line_id
1065: AND zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
1066: AND lnk.application_id = 200

Line 1082: xla_ae_lines ael

1078: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1079: FROM zx_rec_nrec_dist zx_dist,
1080: xla_distribution_links lnk,
1081: xla_ae_headers aeh,
1082: xla_ae_lines ael
1083: WHERE zx_dist.trx_id = c_trx_id
1084: AND zx_dist.trx_line_id = c_trx_line_id
1085: -- AND zx_dist.trx_line_dist_id = c_trx_line_dist_id
1086: AND lnk.application_id = 200

Line 1197: xla_ae_lines xal

1193: FROM ap_invoice_distributions_all aid,
1194: ap_invoices_all ai,
1195: ap_invoice_payments_all aip,
1196: ap_payment_history_all aph,
1197: xla_ae_lines xal
1198: WHERE aid.invoice_id = ai.invoice_id
1199: AND aid.invoice_id = aip.invoice_id
1200: AND aid.distribution_line_number
1201: IN (SELECT distribution_line_number

Line 1240: xla_ae_lines xal

1236: FROM ap_invoice_distributions_all aid,
1237: ap_invoices_all ai,
1238: ap_invoice_payments_all aip,
1239: ap_payment_history_all aph,
1240: xla_ae_lines xal
1241: WHERE aid.invoice_id = ai.invoice_id
1242: AND aid.invoice_id = aip.invoice_id
1243: AND aid.distribution_line_number
1244: IN (SELECT distribution_line_number

Line 1280: xla_ae_lines xal

1276: FROM ap_invoice_distributions_all aid,
1277: ap_invoices_all ai,
1278: ap_invoice_payments_all aip,
1279: ap_payment_history_all aph,
1280: xla_ae_lines xal
1281: WHERE aid.invoice_id = ai.invoice_id
1282: AND aid.invoice_id = aip.invoice_id
1283: -- AND aid.distribution_line_number
1284: AND aid.invoice_distribution_id = p_trx_line_id

Line 1318: xla_ae_lines xal

1314: FROM ap_invoice_distributions_all aid,
1315: ap_invoices_all ai,
1316: ap_invoice_payments_all aip,
1317: ap_payment_history_all aph,
1318: xla_ae_lines xal
1319: WHERE aid.invoice_id = ai.invoice_id
1320: AND aid.invoice_id = aip.invoice_id
1321: -- AND aid.distribution_line_number
1322: AND aid.invoice_distribution_id = p_tax_line_id

Line 1356: xla_ae_lines xal

1352: FROM ap_invoice_distributions_all aid,
1353: ap_invoices_all ai,
1354: ap_invoice_payments_all aip,
1355: ap_payment_history_all aph,
1356: xla_ae_lines xal
1357: WHERE aid.invoice_id = ai.invoice_id
1358: AND aid.invoice_id = aip.invoice_id
1359: -- AND aid.distribution_line_number
1360: AND aid.invoice_distribution_id = p_trx_line_id

Line 1394: xla_ae_lines xal

1390: FROM ap_invoice_distributions_all aid,
1391: ap_invoices_all ai,
1392: ap_invoice_payments_all aip,
1393: ap_payment_history_all aph,
1394: xla_ae_lines xal
1395: WHERE aid.invoice_id = ai.invoice_id
1396: AND aid.invoice_id = aip.invoice_id
1397: -- AND aid.distribution_line_number
1398: AND aid.invoice_distribution_id = p_tax_line_id