DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 155: , OKL_LEASE_OPPORTUNITIES_B LOP

151: SELECT LSQ.REFERENCE_NUMBER LSE_QTE
152: , LOP.REFERENCE_NUMBER LSE_OPP
153: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
154: FROM OKL_LEASE_QUOTES_B LSQ
155: , OKL_LEASE_OPPORTUNITIES_B LOP
156: , OKC_K_HEADERS_B CHR
157: , OKC_STATUSES_V CSTS
158: WHERE CHR.ORIG_SYSTEM_ID1 = LOP.ID
159: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'