APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on XLA_AE_LINES

Line 979: xla_ae_lines ael

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'
982: AND lnk.application_id = 222
983: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

Line 996: xla_ae_lines ael

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
999: AND gl_dist.account_class = 'LINE'
1000: AND lnk.application_id = 222

Line 1018: xla_ae_lines ael

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
1021: AND gl_dist.account_class = 'LINE'
1022: AND lnk.application_id = 222

Line 1037: xla_ae_lines ael

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'
1040: AND lnk.application_id = 222
1041: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

Line 1054: xla_ae_lines ael

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
1057: AND gl_dist.account_class = 'TAX'
1058: AND lnk.application_id = 222

Line 1077: xla_ae_lines ael

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
1080: AND gl_dist.cust_trx_line_gl_dist_id = c_tax_line_dist_id
1081: AND gl_dist.account_class = 'TAX'

Line 1379: xla_ae_lines ael

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
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'

Line 1398: xla_ae_lines ael

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
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'

Line 1420: xla_ae_lines ael

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

Line 1440: xla_ae_lines ael

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

Line 1464: xla_ae_lines ael

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
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'

Line 1487: xla_ae_lines ael

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

Line 1559: xla_ae_lines ael

1555: SELECT
1556: ael.code_combination_id
1557: FROM ar_distributions_all dist,
1558: xla_distribution_links lnk,
1559: xla_ae_lines ael
1560: WHERE dist.line_id = p_actg_source_id
1561: AND lnk.application_id = 222
1562: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1563: AND lnk.source_distribution_id_num_1 = dist.line_id

Line 1575: xla_ae_lines ael

1571: SELECT ael.code_combination_id
1572: FROM ar_distributions_all dist,
1573: ar_distributions_all taxdist,
1574: xla_distribution_links lnk,
1575: xla_ae_lines ael
1576: WHERE taxdist.line_id = p_actg_source_id
1577: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
1578: AND dist.tax_link_id = taxdist.tax_link_id
1579: AND dist.source_id = taxdist.source_id

Line 1594: xla_ae_lines ael

1590: SELECT ael.code_combination_id
1591: FROM ar_distributions_all dist,
1592: ar_distributions_all taxdist,
1593: xla_distribution_links lnk,
1594: xla_ae_lines ael
1595: WHERE dist.line_id = p_actg_source_id
1596: AND NVL(dist.source_table,'X') = NVL(taxdist.source_table_secondary,'X')
1597: AND dist.tax_link_id = taxdist.tax_link_id
1598: AND dist.source_id = taxdist.source_id

Line 1613: xla_ae_lines ael

1609: SELECT
1610: ael.code_combination_id
1611: FROM ar_distributions_all taxdist,
1612: xla_distribution_links lnk,
1613: xla_ae_lines ael
1614: WHERE taxdist.line_id = p_actg_source_id
1615: AND lnk.application_id = 222
1616: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1617: AND lnk.source_distribution_id_num_1 = taxdist.line_id

Line 1905: xla_ae_lines ael

1901: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1902: FROM ar_distributions_all dist,
1903: xla_distribution_links lnk,
1904: xla_ae_headers aeh,
1905: xla_ae_lines ael
1906: WHERE dist.line_id = c_actg_source_id
1907: AND lnk.application_id = 222
1908: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1909: AND lnk.source_distribution_id_num_1 = dist.line_id

Line 1923: xla_ae_lines ael

1919: FROM AR_DISTRIBUTIONS_ALL dist,
1920: AR_DISTRIBUTIONS_ALL taxdist,
1921: xla_distribution_links lnk,
1922: xla_ae_headers aeh,
1923: xla_ae_lines ael
1924: WHERE dist.line_id = c_actg_source_id
1925: AND taxdist.tax_link_id = dist.tax_link_id
1926: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
1927: AND taxdist.source_id = dist.source_id

Line 1946: xla_ae_lines ael

1942: FROM AR_DISTRIBUTIONS_ALL dist,
1943: AR_DISTRIBUTIONS_ALL taxdist,
1944: xla_distribution_links lnk,
1945: xla_ae_headers aeh,
1946: xla_ae_lines ael
1947: WHERE taxdist.line_id = c_actg_source_id
1948: AND taxdist.tax_link_id = dist.tax_link_id
1949: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
1950: AND taxdist.source_id = dist.source_id

Line 1966: xla_ae_lines ael

1962: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1963: FROM ar_distributions_all taxdist,
1964: xla_distribution_links lnk,
1965: xla_ae_headers aeh,
1966: xla_ae_lines ael
1967: WHERE taxdist.line_id = c_actg_source_id
1968: AND lnk.application_id = 222
1969: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1970: AND lnk.source_distribution_id_num_1 = taxdist.line_id