APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 200: FROM OKX_SYSTEM_ITEMS_V syi

196: SELECT syi.id1,
197: syi.id2,
198: syi.name,
199: syi.description
200: FROM OKX_SYSTEM_ITEMS_V syi
201: WHERE syi.VENDOR_WARRANTY_FLAG='N'
202: AND syi.SERVICE_ITEM_FLAG='Y'
203: AND syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
204: AND syi.name = NVL(p_name,syi.name)

Line 216: FROM OKX_SYSTEM_ITEMS_V syi

212: SELECT syi.id1,
213: syi.id2,
214: syi.name,
215: syi.description
216: FROM OKX_SYSTEM_ITEMS_V syi
217: WHERE syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
218: AND syi.name = NVL(p_name,syi.name)
219: AND syi.id1 = NVL(p_id1,syi.id1)
220: AND syi.id2 = NVL(p_id2,syi.id2)

Line 9188: from OKX_SYSTEM_ITEMS_V OKX_SERVICE

9184: CURSOR service_csr IS
9185:
9186: SELECT '1'
9187:
9188: from OKX_SYSTEM_ITEMS_V OKX_SERVICE
9189:
9190: where OKX_SERVICE.VENDOR_WARRANTY_FLAG='N' AND OKX_SERVICE.SERVICE_ITEM_FLAG='Y' AND OKX_SERVICE.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
9191:
9192: AND ID1 = p_id1

Line 9208: from OKX_SYSTEM_ITEMS_V OKX_SYSITEM

9204: CURSOR system_csr IS
9205:
9206: SELECT '1'
9207:
9208: from OKX_SYSTEM_ITEMS_V OKX_SYSITEM
9209:
9210: where
9211: -- 4374085
9212: -- OKX_SYSITEM.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')