DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 18: FROM mtl_item_catalog_groups_b

14: WHERE rownum = 1 AND
15: style_item_flag = l_flag AND
16: item_catalog_group_id IN
17: (SELECT item_catalog_group_id
18: FROM mtl_item_catalog_groups_b
19: CONNECT BY PRIOR item_catalog_group_id = parent_catalog_group_id
20: START WITH item_catalog_group_id = l_catalog_group_id);
21:
22: /*

Line 51: FROM MTL_ITEM_CATALOG_GROUPS_B

47: FROM MTL_SYSTEM_ITEMS_B
48: WHERE STYLE_ITEM_FLAG = 'Y'
49: AND ITEM_CATALOG_GROUP_ID IN
50: ( SELECT ITEM_CATALOG_GROUP_ID
51: FROM MTL_ITEM_CATALOG_GROUPS_B
52: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID = PARENT_CATALOG_GROUP_ID
53: START WITH ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
54: );
55: IF ( l_Style_Item_Count > 0 ) THEN

Line 93: FROM MTL_ITEM_CATALOG_GROUPS_B

89: FROM MTL_SYSTEM_ITEMS_B
90: WHERE STYLE_ITEM_FLAG = 'N'
91: AND ITEM_CATALOG_GROUP_ID IN
92: ( SELECT ITEM_CATALOG_GROUP_ID
93: FROM MTL_ITEM_CATALOG_GROUPS_B
94: CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID = PARENT_CATALOG_GROUP_ID
95: START WITH ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
96: );
97: IF ( l_SKU_Item_Count > 0 ) THEN

Line 512: FROM MTL_ITEM_CATALOG_GROUPS_B micg

508: AND INTF.ORGANIZATION_ID (+) = c_org_id
509: AND AG_EXT.ATTR_GROUP_ID IN (SELECT A.ATTR_GROUP_ID
510: FROM EGO_OBJ_AG_ASSOCS_B a
511: WHERE A.CLASSIFICATION_CODE IN (SELECT To_Char(micg.ITEM_CATALOG_GROUP_ID)
512: FROM MTL_ITEM_CATALOG_GROUPS_B micg
513: CONNECT BY PRIOR micg.PARENT_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID
514: START WITH micg.ITEM_CATALOG_GROUP_ID = c_category_id
515: )
516: )

Line 668: FROM MTL_ITEM_CATALOG_GROUPS_B micg

664: FROM EGO_OBJ_AG_ASSOCS_B a
665: WHERE A.OBJECT_ID = g_ego_item_object_id
666: AND A.DATA_LEVEL_ID = g_ego_item_data_level_id
667: AND A.CLASSIFICATION_CODE IN (SELECT To_Char(micg.ITEM_CATALOG_GROUP_ID)
668: FROM MTL_ITEM_CATALOG_GROUPS_B micg
669: CONNECT BY PRIOR micg.PARENT_CATALOG_GROUP_ID = micg.ITEM_CATALOG_GROUP_ID
670: START WITH micg.ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id));
671:
672: RETURN(0);

Line 710: FROM MTL_ITEM_CATALOG_GROUPS_B

706: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'
707: AND assoc.DATA_LEVEL_ID = g_ego_item_data_level_id
708: AND assoc.OBJECT_ID = g_ego_item_object_id
709: AND assoc.CLASSIFICATION_CODE IN (SELECT TO_CHAR(ITEM_CATALOG_GROUP_ID)
710: FROM MTL_ITEM_CATALOG_GROUPS_B
711: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
712: START WITH ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
713: );
714:

Line 726: FROM MTL_ITEM_CATALOG_GROUPS_B

722: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'
723: AND assoc.DATA_LEVEL_ID = g_ego_item_data_level_id
724: AND assoc.OBJECT_ID = g_ego_item_object_id
725: AND assoc.CLASSIFICATION_CODE IN (SELECT TO_CHAR(ITEM_CATALOG_GROUP_ID)
726: FROM MTL_ITEM_CATALOG_GROUPS_B
727: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
728: START WITH ITEM_CATALOG_GROUP_ID = p_parent_catalog_group_id
729: UNION ALL
730: SELECT TO_CHAR(p_item_catalog_group_id) FROM DUAL