DBA Data[Home] [Help]

APPS.ONT_OEXOHHSA_XMLP_PKG dependencies on OE_SYS_PARAMETERS

Line 142: ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'

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)
144: ,0);
145: ELSE
146: IF OBJECT_TYPE_CODE = 'S' THEN

Line 283: ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'

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)
285: ,0);
286: ELSE
287: IF OBJECT_TYPE_CODE2 = 'S' THEN