DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 636: FROM MTL_ITEM_CATALOG_GROUPS_B ICC

632: WHERE PARAM.ORGANIZATION_ID = MSII.ORGANIZATION_ID
633: AND PARAM.MASTER_ORGANIZATION_ID = PARAM.ORGANIZATION_ID)
634: AND 'Y' =
635: ( SELECT ICC.NEW_ITEM_REQUEST_REQD
636: FROM MTL_ITEM_CATALOG_GROUPS_B ICC
637: WHERE ICC.NEW_ITEM_REQUEST_REQD IS NOT NULL
638: AND ICC.NEW_ITEM_REQUEST_REQD <> 'I'
639: AND ROWNUM = 1
640: CONNECT BY PRIOR ICC.PARENT_CATALOG_GROUP_ID = ICC.ITEM_CATALOG_GROUP_ID

Line 2411: mtl_item_catalog_groups_b.ITEM_CATALOG_GROUP_ID%TYPE;

2407: INDEX BY BINARY_INTEGER;
2408: Item_Catalogs_Table Item_Catalog_Group_Type;
2409:
2410: l_Item_Catalog_Group_ID
2411: mtl_item_catalog_groups_b.ITEM_CATALOG_GROUP_ID%TYPE;
2412: l_Item_Catalog_Group_Name
2413: mtl_system_items_interface.ITEM_CATALOG_GROUP_NAME%TYPE;
2414:
2415: l_Item_Catalog VARCHAR2(2000);

Line 2426: mtl_item_catalog_groups_b_kfv bkfv

2422: DISTINCT msii.ITEM_CATALOG_GROUP_NAME ||
2423: ':' || bkfv.ITEM_CATALOG_GROUP_ID
2424: BULK COLLECT INTO Item_Catalogs_Table
2425: FROM mtl_system_items_interface msii,
2426: mtl_item_catalog_groups_b_kfv bkfv
2427: WHERE msii.ITEM_CATALOG_GROUP_ID IS NULL
2428: AND msii.ITEM_CATALOG_GROUP_NAME IS NOT NULL
2429: AND msii.SET_PROCESS_ID = p_set_id
2430: AND msii.ITEM_CATALOG_GROUP_NAME = bkfv.CONCATENATED_SEGMENTS(+);