DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_STATUSES_V

Line 137: , OKC_STATUSES_V CSTS

133: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
134: FROM OKL_LEASE_APPLICATIONS_B LAB
135: , OKL_LEASE_QUOTES_B QTE
136: , OKC_K_HEADERS_B CHR
137: , OKC_STATUSES_V CSTS
138: WHERE LAB.LEASE_OPPORTUNITY_ID = QTE.PARENT_OBJECT_ID
139: AND QTE.PARENT_OBJECT_CODE = 'LEASEOPP'
140: AND LAB.APPLICATION_STATUS = 'CONV-K'
141: AND LAB.ID = CHR.ORIG_SYSTEM_ID1

Line 157: , OKC_STATUSES_V CSTS

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'
160: AND CSTS.CODE = CHR.STS_CODE
161: AND CSTS.STE_CODE <> 'CANCELLED'