DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_PRODUCTS

Line 15764: FROM okl_lease_opportunities_b lop, okl_lease_quotes_b lsq, okl_products pdt

15760: SELECT lop.currency_code, lop.cust_acct_id, lop.prospect_id, --> (party id)
15761: lop.org_id, lsq.expected_start_date, lop.currency_conversion_type,
15762: lop.currency_conversion_rate, lop.currency_conversion_date, lsq.line_intended_use,
15763: pdt.name
15764: FROM okl_lease_opportunities_b lop, okl_lease_quotes_b lsq, okl_products pdt
15765: WHERE lsq.parent_object_id = lop.id
15766: AND lsq.parent_object_code = 'LEASEOPP'
15767: AND lsq.product_id = pdt.id
15768: AND lsq.id = cp_id;

Line 15776: FROM okl_lease_applications_b lap, okl_lease_quotes_b lsq, okl_products pdt

15772: SELECT lap.currency_code, lap.cust_acct_id, lap.prospect_id, --> (party id)
15773: lap.org_id, lsq.expected_start_date, lap.currency_conversion_type,
15774: lap.currency_conversion_rate, lap.currency_conversion_date, lsq.line_intended_use,
15775: pdt.name
15776: FROM okl_lease_applications_b lap, okl_lease_quotes_b lsq, okl_products pdt
15777: WHERE lsq.parent_object_id = lap.id
15778: AND lsq.parent_object_code = 'LEASEAPP'
15779: AND lsq.primary_quote = 'Y'
15780: AND lsq.product_id = pdt.id