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 AR_DISTRIBUTIONS_ALL

Line 663: FROM AR_DISTRIBUTIONS_ALL ARDTAX,

659: C_TAX_ID IN NUMBER ) IS
660: SELECT SUM(NVL(ARDTAX.AMOUNT_CR,0) - NVL(ARDTAX.AMOUNT_DR,0)),
661: SUM(NVL(ARDTAX.TAXABLE_ENTERED_CR,0) -
662: NVL(ARDTAX.TAXABLE_ENTERED_DR,0))
663: FROM AR_DISTRIBUTIONS_ALL ARDTAX,
664: AR_RECEIVABLE_APPLICATIONS_ALL APP,
665: RA_CUSTOMER_TRX_ALL TRXCM
666: WHERE TRXCM.CUSTOMER_TRX_ID = C_TRX_ID
667: AND APP.APPLIED_CUSTOMER_TRX_ID = TRXCM.CUSTOMER_TRX_ID

Line 1557: FROM ar_distributions_all dist,

1553:
1554: CURSOR trx_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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

Line 1562: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

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
1564: AND lnk.ae_header_id = ael.ae_header_id
1565: AND lnk.ae_line_num = ael.ae_line_num
1566: AND lnk.event_id = c_event_id

Line 1572: FROM ar_distributions_all dist,

1568: AND rownum =1;
1569:
1570: CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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

Line 1573: ar_distributions_all taxdist,

1569:
1570: CURSOR trx_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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')

Line 1582: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1578: AND dist.tax_link_id = taxdist.tax_link_id
1579: AND dist.source_id = taxdist.source_id
1580: AND lnk.source_distribution_id_num_1 = dist.line_id
1581: AND lnk.application_id = 222
1582: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1583: AND lnk.ae_header_id = ael.ae_header_id
1584: AND lnk.ae_line_num = ael.ae_line_num
1585: AND lnk.event_id = c_event_id
1586: AND lnk.ae_header_id = c_ae_header_id

Line 1591: FROM ar_distributions_all dist,

1587: AND rownum =1;
1588:
1589: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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

Line 1592: ar_distributions_all taxdist,

1588:
1589: CURSOR tax_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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')

Line 1601: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1597: AND dist.tax_link_id = taxdist.tax_link_id
1598: AND dist.source_id = taxdist.source_id
1599: AND lnk.source_distribution_id_num_1 = taxdist.line_id
1600: AND lnk.application_id = 222
1601: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1602: AND lnk.ae_header_id = ael.ae_header_id
1603: AND lnk.ae_line_num = ael.ae_line_num
1604: AND lnk.event_id = c_event_id
1605: AND lnk.ae_header_id = c_ae_header_id

Line 1611: FROM ar_distributions_all taxdist,

1607:
1608: CURSOR tax_dist_ccid (c_actg_source_id number, c_event_id number, c_ae_header_id number) IS
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

Line 1616: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

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
1618: AND lnk.ae_header_id = ael.ae_header_id
1619: AND lnk.ae_line_num = ael.ae_line_num
1620: AND lnk.event_id = c_event_id

Line 1902: FROM ar_distributions_all dist,

1898: -- Transaction Header Level
1899: CURSOR taxable_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
1900: c_event_id NUMBER,c_ledger_id NUMBER) IS
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

Line 1908: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

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
1910: AND lnk.ae_header_id = c_ae_header_id
1911: AND lnk.event_id = c_event_id
1912: AND lnk.ae_line_num = ael.ae_line_num

Line 1919: FROM AR_DISTRIBUTIONS_ALL dist,

1915:
1916: CURSOR tax_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
1917: c_event_id NUMBER,c_ledger_id NUMBER) IS
1918: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
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

Line 1920: AR_DISTRIBUTIONS_ALL taxdist,

1916: CURSOR tax_amount_hdr (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
1917: c_event_id NUMBER,c_ledger_id NUMBER) IS
1918: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
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

Line 1930: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1926: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
1927: AND taxdist.source_id = dist.source_id
1928: AND lnk.source_distribution_id_num_1 = taxdist.line_id
1929: AND lnk.application_id = 222
1930: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1931: AND lnk.ae_header_id = c_ae_header_id
1932: AND lnk.event_id = c_event_id
1933: AND lnk.ae_line_num = ael.ae_line_num
1934: AND aeh.ae_header_id = ael.ae_header_id

Line 1942: FROM AR_DISTRIBUTIONS_ALL dist,

1938: -- Transaction Distribution Level
1939:
1940: CURSOR taxable_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
1941: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
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

Line 1943: AR_DISTRIBUTIONS_ALL taxdist,

1939:
1940: CURSOR taxable_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
1941: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
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

Line 1953: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1949: AND NVL(taxdist.source_type_secondary,'X') = NVL(dist.source_type,'X')
1950: AND taxdist.source_id = dist.source_id
1951: AND lnk.source_distribution_id_num_1 = dist.line_id
1952: AND lnk.application_id = 222
1953: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1954: AND lnk.ae_header_id = c_ae_header_id
1955: AND lnk.event_id = c_event_id
1956: AND lnk.ae_line_num = ael.ae_line_num
1957: AND aeh.ae_header_id = ael.ae_header_id

Line 1963: FROM ar_distributions_all taxdist,

1959:
1960: CURSOR tax_amount_dist (c_actg_source_id NUMBER, c_ae_header_id NUMBER,
1961: c_event_id NUMBER,c_ledger_id NUMBER) IS
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

Line 1969: AND lnk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

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
1971: AND lnk.ae_header_id = c_ae_header_id
1972: AND lnk.event_id = c_event_id
1973: AND lnk.ae_line_num = ael.ae_line_num