DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_PRODUCTS

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

15688: SELECT lop.currency_code, lop.cust_acct_id, lop.prospect_id, --> (party id)
15689: lop.org_id, lsq.expected_start_date, lop.currency_conversion_type,
15690: lop.currency_conversion_rate, lop.currency_conversion_date, lsq.line_intended_use,
15691: pdt.name
15692: FROM okl_lease_opportunities_b lop, okl_lease_quotes_b lsq, okl_products pdt
15693: WHERE lsq.parent_object_id = lop.id
15694: AND lsq.parent_object_code = 'LEASEOPP'
15695: AND lsq.product_id = pdt.id
15696: AND lsq.id = cp_id;

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

15700: SELECT lap.currency_code, lap.cust_acct_id, lap.prospect_id, --> (party id)
15701: lap.org_id, lsq.expected_start_date, lap.currency_conversion_type,
15702: lap.currency_conversion_rate, lap.currency_conversion_date, lsq.line_intended_use,
15703: pdt.name
15704: FROM okl_lease_applications_b lap, okl_lease_quotes_b lsq, okl_products pdt
15705: WHERE lsq.parent_object_id = lap.id
15706: AND lsq.parent_object_code = 'LEASEAPP'
15707: AND lsq.primary_quote = 'Y'
15708: AND lsq.product_id = pdt.id