DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_STATUSES_V

Line 135: , OKC_STATUSES_V CSTS

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

Line 155: , OKC_STATUSES_V CSTS

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