APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_TAX_SOURCES

Line 848: from okl_tax_sources txs

844: vendor.vendor_type_lookup_code VENDOR_TYPE_CODE,
845: CPL.bill_to_site_use_id VENDOR_BILL_TO_SITE_USE_ID,
846: cpl.role VENDOR_PARTY_ROLE,
847: (select nvl(SUM(NVL(txs.total_tax,0)),0)
848: from okl_tax_sources txs
849: where txs.khr_id = khr.id
850: AND txs.tax_line_status_code = 'ACTIVE'
851: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
852: -- null TOTAL_NUMBER_OF_ASSETS,

Line 1881: from okl_tax_sources txs

1877: vendor.vendor_type_lookup_code VENDOR_TYPE_CODE,
1878: CPL.bill_to_site_use_id VENDOR_BILL_TO_SITE_USE_ID,
1879: cpl.role VENDOR_PARTY_ROLE,
1880: (select nvl(SUM(NVL(txs.total_tax,0)),0)
1881: from okl_tax_sources txs
1882: where txs.khr_id = khr.id
1883: AND txs.tax_line_status_code = 'ACTIVE'
1884: AND txs.tax_call_type_code = 'UPFRONT_TAX') TOTAL_UPFRONT_TAX_ON_ASSETS,
1885: -- null TOTAL_NUMBER_OF_ASSETS,