APPS.INVPOPIF dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 471: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

467: WHERE PARAM.ORGANIZATION_ID = MSII.ORGANIZATION_ID
468: AND PARAM.MASTER_ORGANIZATION_ID = PARAM.ORGANIZATION_ID)
469: AND 'Y' =
470: ( SELECT ICC.NEW_ITEM_REQUEST_REQD
471: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
472: WHERE ICC.NEW_ITEM_REQUEST_REQD IS NOT NULL
473: AND ICC.NEW_ITEM_REQUEST_REQD <> 'I'
474: AND ROWNUM = 1
475: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID

Line 2187: mtl_item_catalog_groups_b.ITEM_CATALOG_GROUP_ID%TYPE;

2183: INDEX BY BINARY_INTEGER;
2184: Item_Catalogs_Table Item_Catalog_Group_Type;
2185:
2186: l_Item_Catalog_Group_ID
2187: mtl_item_catalog_groups_b.ITEM_CATALOG_GROUP_ID%TYPE;
2188: l_Item_Catalog_Group_Name
2189: mtl_system_items_interface.ITEM_CATALOG_GROUP_NAME%TYPE;
2190:
2191: l_Item_Catalog VARCHAR2(2000);

Line 2200: mtl_item_catalog_groups_b_kfv bkfv

2196: SELECT DISTINCT msii.ITEM_CATALOG_GROUP_NAME ||
2197: ':' || bkfv.ITEM_CATALOG_GROUP_ID
2198: BULK COLLECT INTO Item_Catalogs_Table
2199: FROM mtl_system_items_interface msii,
2200: mtl_item_catalog_groups_b_kfv bkfv
2201: WHERE msii.ITEM_CATALOG_GROUP_ID IS NULL
2202: AND msii.ITEM_CATALOG_GROUP_NAME IS NOT NULL
2203: AND msii.SET_PROCESS_ID = p_set_id
2204: AND msii.ITEM_CATALOG_GROUP_NAME = bkfv.CONCATENATED_SEGMENTS(+);