DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKC_K_HEADERS_B

Line 1799: from okc_k_headers_b khr

1795: -- khr.contract_number,
1796: (case
1797: when pool.source_type_code = 'LEASE_CONTRACT' then
1798: (select khr.contract_number
1799: from okc_k_headers_b khr
1800: where khr.id = pool.source_object_id)
1801: --START:| 26-JAN-05 cklee - Fixed bug#5002229 |
1802: -- when pool.source_type_code in ('SALES_QUOTE', 'LEASE_APPLICATION') then
1803: when pool.source_type_code = 'SALES_QUOTE' then

Line 1842: --, okc_k_headers_b khr

1838: -- abindal start bug# 4873705 --
1839: hr_organization_units hru
1840: -- abindal end bug# 4873705 --
1841: --START:14-DEC-05 cklee - Fixed bug#4884558 |
1842: --, okc_k_headers_b khr
1843: --END:14-DEC-05 cklee - Fixed bug#4884558 |
1844: WHERE flk1.lookup_type = 'OKL_SUB_POOL_TRX_REASON_TYPE'
1845: AND flk1.lookup_code = pool.trx_reason_code
1846: AND vend.vendor_id = pool.vendor_id

Line 3989: from okc_k_headers_b khr

3985: SELECT flk1.meaning trx_reason,
3986: (case
3987: when pool.source_type_code = 'LEASE_CONTRACT' then
3988: (select khr.contract_number
3989: from okc_k_headers_b khr
3990: where khr.id = pool.source_object_id)
3991: when pool.source_type_code = 'SALES_QUOTE' then
3992: (select sq.reference_number
3993: from okl_lease_quotes_b sq