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_HEADERS

Line 981: xla_ae_headers aeh,

977: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
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'

Line 999: xla_ae_headers aeh,

995: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
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'

Line 1019: xla_ae_headers aeh,

1015: c_event_id NUMBER, c_ledger_id NUMBER) IS
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

Line 1038: xla_ae_headers aeh,

1034: c_event_id NUMBER, c_ledger_id NUMBER) IS
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

Line 1061: xla_ae_headers aeh,

1057: c_event_id NUMBER, c_ledger_id NUMBER) IS
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

Line 1081: xla_ae_headers aeh,

1077: c_event_id NUMBER, c_ledger_id NUMBER) IS
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