APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 34: FROM MTL_ITEM_CATALOG_GROUPS_B

30: FROM MTL_SYSTEM_ITEMS_B
31: WHERE STYLE_ITEM_FLAG = 'Y'
32: AND ITEM_CATALOG_GROUP_ID IN
33: ( SELECT ITEM_CATALOG_GROUP_ID
34: FROM MTL_ITEM_CATALOG_GROUPS_B
35: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID = PARENT_CATALOG_GROUP_ID
36: START WITH ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
37: );
38: IF ( l_Style_Item_Count > 0 ) THEN

Line 62: FROM MTL_ITEM_CATALOG_GROUPS_B

58: FROM MTL_SYSTEM_ITEMS_B
59: WHERE STYLE_ITEM_FLAG = 'N'
60: AND ITEM_CATALOG_GROUP_ID IN
61: ( SELECT ITEM_CATALOG_GROUP_ID
62: FROM MTL_ITEM_CATALOG_GROUPS_B
63: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID = PARENT_CATALOG_GROUP_ID
64: START WITH ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
65: );
66: IF ( l_SKU_Item_Count > 0 ) THEN

Line 448: FROM MTL_ITEM_CATALOG_GROUPS_B micg

444: AND INTF.ORGANIZATION_ID (+) = c_org_id
445: AND AG_EXT.ATTR_GROUP_ID IN (SELECT A.ATTR_GROUP_ID
446: FROM EGO_OBJ_AG_ASSOCS_B a
447: WHERE A.CLASSIFICATION_CODE IN (SELECT To_Char(micg.ITEM_CATALOG_GROUP_ID)
448: FROM MTL_ITEM_CATALOG_GROUPS_B micg
449: CONNECT BY PRIOR micg.PARENT_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID
450: START WITH micg.ITEM_CATALOG_GROUP_ID = c_category_id
451: )
452: )

Line 602: FROM MTL_ITEM_CATALOG_GROUPS_B micg

598: AND AG_EXT.VARIANT = 'Y'
599: AND AG_EXT.ATTR_GROUP_ID IN (SELECT A.ATTR_GROUP_ID
600: FROM EGO_OBJ_AG_ASSOCS_B a
601: WHERE A.CLASSIFICATION_CODE IN (SELECT To_Char(micg.ITEM_CATALOG_GROUP_ID)
602: FROM MTL_ITEM_CATALOG_GROUPS_B micg
603: CONNECT BY PRIOR micg.PARENT_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID
604: START WITH micg.ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
605: )
606: );

Line 646: FROM MTL_ITEM_CATALOG_GROUPS_B

642: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'
643: AND assoc.DATA_LEVEL_ID = l_item_data_level_id
644: AND assoc.OBJECT_ID = l_itm_obj_id
645: AND assoc.CLASSIFICATION_CODE IN (SELECT TO_CHAR(ITEM_CATALOG_GROUP_ID)
646: FROM MTL_ITEM_CATALOG_GROUPS_B
647: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
648: START WITH ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
649: );
650:

Line 662: FROM MTL_ITEM_CATALOG_GROUPS_B

658: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'
659: AND assoc.DATA_LEVEL_ID = l_item_data_level_id
660: AND assoc.OBJECT_ID = l_itm_obj_id
661: AND assoc.CLASSIFICATION_CODE IN (SELECT TO_CHAR(ITEM_CATALOG_GROUP_ID)
662: FROM MTL_ITEM_CATALOG_GROUPS_B
663: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
664: START WITH ITEM_CATALOG_GROUP_ID = p_parent_catalog_group_id
665: UNION ALL
666: SELECT TO_CHAR(p_item_catalog_group_id) FROM DUAL