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 551: xla_ae_lines ael

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

Line 571: xla_ae_lines ael

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

Line 592: xla_ae_lines ael

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

Line 611: xla_ae_lines ael

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

Line 628: xla_ae_lines ael

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

Line 650: xla_ae_lines ael

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

Line 979: xla_ae_lines ael

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

Line 997: xla_ae_lines ael

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

Line 1017: xla_ae_lines ael

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

Line 1036: xla_ae_lines ael

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

Line 1059: xla_ae_lines ael

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

Line 1079: xla_ae_lines ael

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

Line 1194: xla_ae_lines xal

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

Line 1237: xla_ae_lines xal

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

Line 1277: xla_ae_lines xal

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

Line 1315: xla_ae_lines xal

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

Line 1353: xla_ae_lines xal

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

Line 1391: xla_ae_lines xal

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