DBA Data[Home] [Help]

APPS.ONT_OEXOHHSA_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 139: MTL_SYSTEM_ITEMS_VL

135: SELECT
136: DESCRIPTION
137: INTO L_ENTITY_VALUE
138: FROM
139: MTL_SYSTEM_ITEMS_VL
140: WHERE INVENTORY_ITEM_ID = OBJECT_ID
141: AND NVL(ORGANIZATION_ID
142: ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
143: ,MO_GLOBAL.GET_CURRENT_ORG_ID)

Line 280: MTL_SYSTEM_ITEMS_VL

276: SELECT
277: DESCRIPTION
278: INTO L_ENTITY_VALUE
279: FROM
280: MTL_SYSTEM_ITEMS_VL
281: WHERE INVENTORY_ITEM_ID = OBJECT_ID2
282: AND NVL(ORGANIZATION_ID
283: ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
284: ,MO_GLOBAL.GET_CURRENT_ORG_ID)