DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1839: RA_CUSTOMER_TRX_ALL AR,

1835: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1836: FROM
1837: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1838: JG_ZZ_VAT_REP_STATUS JZVRS,
1839: RA_CUSTOMER_TRX_ALL AR,
1840: RA_CUSTOMER_TRX_LINES_ALL ARL
1841: WHERE
1842: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1843: AND JZVRS.SOURCE = 'AR'

Line 1885: RA_CUSTOMER_TRX_ALL AR

1881: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1882: FROM
1883: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1884: JG_ZZ_VAT_REP_STATUS JZVRS,
1885: RA_CUSTOMER_TRX_ALL AR
1886: WHERE
1887: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1888: AND JZVRS.SOURCE = 'AR'
1889: AND JZVRS.VAT_REPORTING_ENTITY_ID in

Line 1928: RA_CUSTOMER_TRX_ALL AR

1924: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1925: FROM
1926: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1927: JG_ZZ_VAT_REP_STATUS JZVRS,
1928: RA_CUSTOMER_TRX_ALL AR
1929: WHERE
1930: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1931: AND JZVRS.SOURCE = 'AR'
1932: AND JZVRS.VAT_REPORTING_ENTITY_ID in

Line 1976: RA_CUSTOMER_TRX_ALL AR

1972: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1973: FROM
1974: JG_ZZ_VAT_TRX_DETAILS JZVTD,
1975: JG_ZZ_VAT_REP_STATUS JZVRS,
1976: RA_CUSTOMER_TRX_ALL AR
1977: WHERE
1978: JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID
1979: AND JZVRS.SOURCE = 'AR'
1980: AND JZVRS.VAT_REPORTING_ENTITY_ID in