DBA Data[Home] [Help]

APPS.ONT_OEXOEOCS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 30: MTL_SYSTEM_ITEMS_KFV

26: SELECT
27: CONCATENATED_SEGMENTS
28: INTO P_ITEM_NAME
29: FROM
30: MTL_SYSTEM_ITEMS_KFV
31: WHERE INVENTORY_ITEM_ID = P_ITEM
32: AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
33: AND BOM_ITEM_TYPE in ( 1 , 4 )
34: AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');