DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_TAX_SOURCES

Line 862: from okl_tax_sources txs

858: vendor.vendor_type_lookup_code VENDOR_TYPE_CODE,
859: CPL.bill_to_site_use_id VENDOR_BILL_TO_SITE_USE_ID,
860: cpl.role VENDOR_PARTY_ROLE,
861: (select nvl(SUM(NVL(txs.total_tax,0)),0)
862: from okl_tax_sources txs
863: where txs.khr_id = khr.id
864: AND txs.tax_line_status_code = 'ACTIVE'
865: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
866: -- null TOTAL_NUMBER_OF_ASSETS,

Line 1895: from okl_tax_sources txs

1891: vendor.vendor_type_lookup_code VENDOR_TYPE_CODE,
1892: CPL.bill_to_site_use_id VENDOR_BILL_TO_SITE_USE_ID,
1893: cpl.role VENDOR_PARTY_ROLE,
1894: (select nvl(SUM(NVL(txs.total_tax,0)),0)
1895: from okl_tax_sources txs
1896: where txs.khr_id = khr.id
1897: AND txs.tax_line_status_code = 'ACTIVE'
1898: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
1899: -- null TOTAL_NUMBER_OF_ASSETS,