DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 153: , OKL_LEASE_OPPORTUNITIES_B LOP

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