DBA Data[Home] [Help]

APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 1866: FROM mtl_item_categories_interface mici

1862:
1863: CURSOR icoi_csr (p_set_process_id NUMBER) IS
1864: SELECT mici.inventory_item_id
1865: ,mp.organization_id
1866: FROM mtl_item_categories_interface mici
1867: ,mtl_parameters mp
1868: WHERE mici.set_process_id = p_set_process_id
1869: AND mici.request_id = l_conc_request_id
1870: AND mici.process_flag = l_process_flag

Line 1966: FROM mtl_item_categories_interface

1962:
1963: -- updating Item Assignment flag for all categories,
1964: -- which have items attached to it
1965: FOR intf_categories_add IN (SELECT DISTINCT CATEGORY_ID
1966: FROM mtl_item_categories_interface
1967: WHERE process_flag = 7
1968: AND transaction_type IN ('CREATE','UPDATE')
1969: AND set_process_id = p_set_process_id
1970: AND category_set_id = l_vbh_category_set_id)

Line 2000: FROM mtl_item_categories_interface

1996: (SELECT DISTINCT
1997: Decode(TRANSACTION_TYPE,
1998: 'UPDATE',OLD_CATEGORY_ID,
1999: CATEGORY_ID) AS CATEGORY_ID
2000: FROM mtl_item_categories_interface
2001: WHERE process_flag = 7
2002: AND TRANSACTION_TYPE IN ('DELETE','UPDATE')
2003: AND set_process_id = p_set_process_id
2004: AND category_set_id = l_vbh_category_set_id)