APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 184: FROM OKX_SYSTEM_ITEMS_V syi

180: SELECT syi.id1,
181: syi.id2,
182: syi.name,
183: syi.description
184: FROM OKX_SYSTEM_ITEMS_V syi
185: WHERE syi.VENDOR_WARRANTY_FLAG='N'
186: AND syi.SERVICE_ITEM_FLAG='Y'
187: AND syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
188: AND syi.name = NVL(p_name,syi.name)

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.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
202: AND syi.name = NVL(p_name,syi.name)
203: AND syi.id1 = NVL(p_id1,syi.id1)
204: AND syi.id2 = NVL(p_id2,syi.id2)

Line 9126: from OKX_SYSTEM_ITEMS_V OKX_SERVICE

9122: CURSOR service_csr IS
9123:
9124: SELECT '1'
9125:
9126: from OKX_SYSTEM_ITEMS_V OKX_SERVICE
9127:
9128: 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')
9129:
9130: AND ID1 = p_id1

Line 9146: from OKX_SYSTEM_ITEMS_V OKX_SYSITEM

9142: CURSOR system_csr IS
9143:
9144: SELECT '1'
9145:
9146: from OKX_SYSTEM_ITEMS_V OKX_SYSITEM
9147:
9148: where
9149: -- 4374085
9150: -- OKX_SYSITEM.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')