DBA Data[Home] [Help]

APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 140: FROM OKX_SYSTEM_ITEMS_V syi

136: SELECT syi.id1,
137: syi.id2,
138: syi.name,
139: syi.description
140: FROM OKX_SYSTEM_ITEMS_V syi
141: WHERE syi.VENDOR_WARRANTY_FLAG='N'
142: AND syi.SERVICE_ITEM_FLAG='Y'
143: AND syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
144: AND syi.name = NVL(p_name,syi.name)

Line 156: FROM OKX_SYSTEM_ITEMS_V syi

152: SELECT syi.id1,
153: syi.id2,
154: syi.name,
155: syi.description
156: FROM OKX_SYSTEM_ITEMS_V syi
157: WHERE syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
158: AND syi.name = NVL(p_name,syi.name)
159: AND syi.id1 = NVL(p_id1,syi.id1)
160: AND syi.id2 = NVL(p_id2,syi.id2)