APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_LEASE_QUOTES_B

Line 1806: from okl_lease_quotes_b sq

1802: -- when pool.source_type_code in ('SALES_QUOTE', 'LEASE_APPLICATION') then
1803: when pool.source_type_code = 'SALES_QUOTE' then
1804: --END| 26-JAN-05 cklee - Fixed bug#5002229 |
1805: (select sq.reference_number
1806: from okl_lease_quotes_b sq
1807: where sq.id = pool.source_object_id)
1808: --START:| 26-JAN-05 cklee - Fixed bug#5002229 |
1809: when pool.source_type_code = 'LEASE_APPLICATION' then
1810: --END| 26-JAN-05 cklee - Fixed bug#5002229 |

Line 1813: okl_lease_quotes_b lsq

1809: when pool.source_type_code = 'LEASE_APPLICATION' then
1810: --END| 26-JAN-05 cklee - Fixed bug#5002229 |
1811: (select lap.reference_number
1812: from okl_lease_applications_b lap,
1813: okl_lease_quotes_b lsq
1814: where lsq.parent_object_id = lap.id
1815: and lsq.parent_object_code = 'LEASEAPP'
1816: and lsq.id = pool.source_object_id)
1817: --END| 26-JAN-05 cklee - Fixed bug#5002229 |

Line 3993: from okl_lease_quotes_b sq

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
3994: where sq.id = pool.source_object_id)
3995: when pool.source_type_code = 'LEASE_APPLICATION' then
3996: (select lap.reference_number
3997: from okl_lease_applications_b lap,

Line 3998: okl_lease_quotes_b lsq

3994: where sq.id = pool.source_object_id)
3995: when pool.source_type_code = 'LEASE_APPLICATION' then
3996: (select lap.reference_number
3997: from okl_lease_applications_b lap,
3998: okl_lease_quotes_b lsq
3999: where lsq.parent_object_id = lap.id
4000: and lsq.parent_object_code = 'LEASEAPP'
4001: and lsq.id = pool.source_object_id)
4002: end) contract_number,