DBA Data[Home] [Help]

APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 2050: FROM mtl_item_categories_interface mici

2046:
2047: CURSOR icoi_csr (p_set_process_id NUMBER) IS
2048: SELECT mici.inventory_item_id
2049: ,mp.organization_id
2050: FROM mtl_item_categories_interface mici
2051: ,mtl_parameters mp
2052: WHERE mici.set_process_id = p_set_process_id
2053: AND mici.request_id = l_conc_request_id
2054: AND mici.process_flag = l_process_flag

Line 2150: FROM mtl_item_categories_interface

2146:
2147: -- updating Item Assignment flag for all categories,
2148: -- which have items attached to it
2149: FOR intf_categories_add IN (SELECT DISTINCT CATEGORY_ID
2150: FROM mtl_item_categories_interface
2151: WHERE process_flag = 7
2152: AND transaction_type IN ('CREATE','UPDATE')
2153: AND set_process_id = p_set_process_id
2154: AND category_set_id = l_vbh_category_set_id)

Line 2184: FROM mtl_item_categories_interface

2180: (SELECT DISTINCT
2181: Decode(TRANSACTION_TYPE,
2182: 'UPDATE',OLD_CATEGORY_ID,
2183: CATEGORY_ID) AS CATEGORY_ID
2184: FROM mtl_item_categories_interface
2185: WHERE process_flag = 7
2186: AND TRANSACTION_TYPE IN ('DELETE','UPDATE')
2187: AND set_process_id = p_set_process_id
2188: AND category_set_id = l_vbh_category_set_id)