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_DISTRIBUTION_LINKS

Line 553: xla_distribution_links lnk,

549: CURSOR trx_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
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'

Line 573: xla_distribution_links lnk,

569: c_ae_header_id NUMBER) IS
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

Line 594: xla_distribution_links lnk,

590: CURSOR trx_dist_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
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

Line 613: xla_distribution_links lnk,

609: CURSOR tax_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
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'

Line 630: xla_distribution_links lnk,

626: CURSOR tax_line_ccid (c_trx_id number, c_tax_line_id NUMBER, c_event_id number, c_ae_header_id number) IS
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

Line 652: xla_distribution_links lnk,

648: c_event_id number, c_ae_header_id number) IS
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

Line 980: xla_distribution_links lnk,

976:
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

Line 998: xla_distribution_links lnk,

994:
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

Line 1018: xla_distribution_links lnk,

1014: CURSOR taxable_amount_line (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
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

Line 1037: xla_distribution_links lnk,

1033: CURSOR tax_amount_line (c_trx_id NUMBER,c_tax_line_id NUMBER, c_ae_header_id NUMBER,
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

Line 1060: xla_distribution_links lnk,

1056: CURSOR tax_amount_dist ( c_trx_id NUMBER,c_tax_line_id NUMBER, c_tax_dist_id NUMBER, c_ae_header_id NUMBER,
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

Line 1080: xla_distribution_links lnk,

1076: CURSOR taxable_amount_dist (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
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