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_AR_ACTG_POPULATE_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 977: FROM ra_cust_trx_line_gl_dist_all gl_dist,

973: i IN binary_integer) IS
974: CURSOR trx_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
975: SELECT
976: ael.code_combination_id
977: FROM ra_cust_trx_line_gl_dist_all gl_dist,
978: xla_distribution_links lnk,
979: xla_ae_lines ael
980: WHERE gl_dist.customer_trx_id = c_trx_id
981: AND gl_dist.account_class = 'LINE'

Line 983: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

979: xla_ae_lines ael
980: WHERE gl_dist.customer_trx_id = c_trx_id
981: AND gl_dist.account_class = 'LINE'
982: AND lnk.application_id = 222
983: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
984: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
985: AND lnk.ae_header_id = ael.ae_header_id
986: AND lnk.ae_line_num = ael.ae_line_num
987: AND lnk.event_id = c_event_id

Line 994: FROM ra_cust_trx_line_gl_dist_all gl_dist,

990:
991: CURSOR trx_line_ccid (c_trx_id number, c_trx_line_id number, c_event_id number, c_ae_header_id NUMBER) IS
992: SELECT
993: ael.code_combination_id
994: FROM ra_cust_trx_line_gl_dist_all gl_dist,
995: xla_distribution_links lnk,
996: xla_ae_lines ael
997: WHERE gl_dist.customer_trx_id = c_trx_id
998: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 1001: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

997: WHERE gl_dist.customer_trx_id = c_trx_id
998: AND gl_dist.customer_trx_line_id = c_trx_line_id
999: AND gl_dist.account_class = 'LINE'
1000: AND lnk.application_id = 222
1001: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1002: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1003: AND lnk.ae_header_id = ael.ae_header_id
1004: AND lnk.ae_line_num = ael.ae_line_num
1005: AND lnk.event_id = c_event_id

Line 1016: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1012:
1013: CURSOR trx_dist_ccid (c_trx_id NUMBER, c_trx_line_id NUMBER, c_event_id NUMBER, c_ae_header_id NUMBER) IS
1014: SELECT
1015: ael.code_combination_id
1016: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1017: xla_distribution_links lnk,
1018: xla_ae_lines ael
1019: WHERE gl_dist.customer_trx_id = c_trx_id
1020: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 1023: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1019: WHERE gl_dist.customer_trx_id = c_trx_id
1020: AND gl_dist.customer_trx_line_id = c_trx_line_id
1021: AND gl_dist.account_class = 'LINE'
1022: AND lnk.application_id = 222
1023: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1024: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1025: AND lnk.ae_header_id = ael.ae_header_id
1026: AND lnk.ae_line_num = ael.ae_line_num
1027: AND lnk.event_id = c_event_id

Line 1035: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1031:
1032: CURSOR tax_ccid (c_trx_id number, c_event_id number, c_ae_header_id number) IS
1033: SELECT
1034: ael.code_combination_id
1035: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1036: xla_distribution_links lnk,
1037: xla_ae_lines ael
1038: WHERE gl_dist.customer_trx_id = c_trx_id
1039: AND gl_dist.account_class = 'TAX'

Line 1041: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1037: xla_ae_lines ael
1038: WHERE gl_dist.customer_trx_id = c_trx_id
1039: AND gl_dist.account_class = 'TAX'
1040: AND lnk.application_id = 222
1041: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1042: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1043: AND lnk.ae_header_id = ael.ae_header_id
1044: AND lnk.ae_line_num = ael.ae_line_num
1045: AND lnk.event_id = c_event_id

Line 1052: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1048:
1049: CURSOR tax_line_ccid (c_trx_id number, c_tax_line_id NUMBER, c_event_id number, c_ae_header_id number) IS
1050: SELECT
1051: ael.code_combination_id
1052: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1053: xla_distribution_links lnk,
1054: xla_ae_lines ael
1055: WHERE gl_dist.customer_trx_id = c_trx_id
1056: AND gl_dist.customer_trx_line_id = c_tax_line_id

Line 1059: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1055: WHERE gl_dist.customer_trx_id = c_trx_id
1056: AND gl_dist.customer_trx_line_id = c_tax_line_id
1057: AND gl_dist.account_class = 'TAX'
1058: AND lnk.application_id = 222
1059: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1060: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1061: AND lnk.ae_header_id = ael.ae_header_id
1062: AND lnk.ae_line_num = ael.ae_line_num
1063: AND lnk.event_id = c_event_id

Line 1075: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1071: CURSOR tax_dist_ccid (c_trx_id NUMBER, c_tax_line_id NUMBER, c_tax_line_dist_id NUMBER,
1072: c_event_id number, c_ae_header_id number) IS
1073: SELECT
1074: ael.code_combination_id
1075: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1076: xla_distribution_links lnk,
1077: xla_ae_lines ael
1078: WHERE gl_dist.customer_trx_id = c_trx_id
1079: AND gl_dist.customer_trx_line_id = c_tax_line_id

Line 1083: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1079: AND gl_dist.customer_trx_line_id = c_tax_line_id
1080: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id
1081: AND gl_dist.account_class = 'TAX'
1082: AND lnk.application_id = 222
1083: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1084: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1085: AND lnk.ae_header_id = ael.ae_header_id
1086: AND lnk.ae_line_num = ael.ae_line_num
1087: AND lnk.event_id = c_event_id

Line 1376: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1372: -- Transaction Header Level
1373:
1374: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
1375: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1376: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1377: xla_distribution_links lnk,
1378: xla_ae_headers aeh,
1379: xla_ae_lines ael
1380: WHERE gl_dist.customer_trx_id = c_trx_id

Line 1383: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1379: xla_ae_lines ael
1380: WHERE gl_dist.customer_trx_id = c_trx_id
1381: AND lnk.application_id = 222
1382: AND gl_dist.account_class = 'REV'
1383: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1384: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1385: AND lnk.ae_header_id = c_ae_header_id
1386: AND lnk.event_id = c_event_id
1387: AND lnk.ae_line_num = ael.ae_line_num

Line 1395: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1391:
1392:
1393: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
1394: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1395: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1396: xla_distribution_links lnk,
1397: xla_ae_headers aeh,
1398: xla_ae_lines ael
1399: WHERE gl_dist.customer_trx_id = c_trx_id

Line 1402: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1398: xla_ae_lines ael
1399: WHERE gl_dist.customer_trx_id = c_trx_id
1400: AND gl_dist.account_class = 'TAX'
1401: AND lnk.application_id = 222
1402: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1403: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1404: AND lnk.ae_header_id = c_ae_header_id
1405: AND lnk.event_id = c_event_id
1406: AND lnk.ae_line_num = ael.ae_line_num

Line 1417: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1413:
1414: CURSOR taxable_amount_line (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
1415: c_event_id NUMBER, c_ledger_id NUMBER) IS
1416: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1417: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1418: xla_distribution_links lnk,
1419: xla_ae_headers aeh,
1420: xla_ae_lines ael
1421: WHERE gl_dist.customer_trx_id = c_trx_id

Line 1425: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1421: WHERE gl_dist.customer_trx_id = c_trx_id
1422: AND gl_dist.customer_trx_line_id = c_trx_line_id
1423: AND gl_dist.account_class = 'REV'
1424: AND lnk.application_id = 222
1425: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1426: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1427: AND lnk.ae_header_id = c_ae_header_id
1428: AND lnk.event_id = c_event_id
1429: AND lnk.ae_line_num = ael.ae_line_num

Line 1437: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1433:
1434:
1435: CURSOR tax_amount_line (c_trx_id NUMBER,c_tax_line_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
1436: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1437: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1438: xla_distribution_links lnk,
1439: xla_ae_headers aeh,
1440: xla_ae_lines ael
1441: WHERE gl_dist.customer_trx_id = c_trx_id

Line 1445: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1441: WHERE gl_dist.customer_trx_id = c_trx_id
1442: AND gl_dist.customer_trx_line_id = c_tax_line_id
1443: AND gl_dist.account_class = 'TAX'
1444: AND lnk.application_id = 222
1445: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1446: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1447: AND lnk.event_id = c_event_id
1448: AND lnk.ae_header_id = c_ae_header_id
1449: AND lnk.ae_line_num = ael.ae_line_num

Line 1461: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1457:
1458: CURSOR tax_amount_dist ( c_trx_id NUMBER,c_tax_line_id NUMBER, c_tax_dist_id NUMBER, c_ae_header_id NUMBER,
1459: c_event_id NUMBER, c_ledger_id NUMBER) IS
1460: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1461: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1462: xla_distribution_links lnk,
1463: xla_ae_headers aeh,
1464: xla_ae_lines ael
1465: WHERE gl_dist.customer_trx_id = c_trx_id

Line 1470: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1466: AND gl_dist.customer_trx_line_id = c_tax_line_id
1467: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_dist_id
1468: AND gl_dist.account_class = 'TAX'
1469: AND lnk.application_id = 222
1470: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1471: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1472: AND lnk.ae_header_id = ael.ae_header_id
1473: AND lnk.ae_line_num = ael.ae_line_num
1474: AND lnk.event_id = c_event_id

Line 1484: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1480:
1481: CURSOR taxable_amount_dist (c_trx_id NUMBER,c_trx_line_id NUMBER, c_ae_header_id NUMBER,
1482: c_event_id NUMBER, c_ledger_id NUMBER) IS
1483: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1484: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1485: xla_distribution_links lnk,
1486: xla_ae_headers aeh,
1487: xla_ae_lines ael
1488: WHERE gl_dist.customer_trx_id = c_trx_id

Line 1492: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1488: WHERE gl_dist.customer_trx_id = c_trx_id
1489: AND gl_dist.customer_trx_line_id = c_trx_line_id
1490: AND gl_dist.account_class = 'LINE'
1491: AND lnk.application_id = 222
1492: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1493: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1494: AND lnk.ae_header_id = c_ae_header_id
1495: AND lnk.event_id = c_event_id
1496: AND lnk.ae_line_num = ael.ae_line_num