APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 446: FROM EGO_OBJ_AG_ASSOCS_B a

442: AND INTF.PROCESS_STATUS (+) = 2
443: AND INTF.INVENTORY_ITEM_ID (+) = c_item_id /* OR INTF.ITEM_NUMBER (+)= c_item_number*/
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

Line 600: FROM EGO_OBJ_AG_ASSOCS_B a

596: AND ATTR_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE /* AG_NAME*/
597: AND ATTR_EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME /* DATABASE_COLUMN */
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

Line 638: EGO_OBJ_AG_ASSOCS_B assoc,

634:
635: CURSOR c_existing_variants IS
636: SELECT assoc.ATTR_GROUP_ID
637: FROM
638: EGO_OBJ_AG_ASSOCS_B assoc,
639: EGO_FND_DSC_FLX_CTX_EXT ag_ext
640: WHERE assoc.ATTR_GROUP_ID = AG_EXT.ATTR_GROUP_ID
641: AND NVL(ag_ext.VARIANT, 'N') = 'Y'
642: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'

Line 654: EGO_OBJ_AG_ASSOCS_B assoc,

650:
651: CURSOR c_new_variants IS
652: SELECT assoc.ATTR_GROUP_ID
653: FROM
654: EGO_OBJ_AG_ASSOCS_B assoc,
655: EGO_FND_DSC_FLX_CTX_EXT ag_ext
656: WHERE assoc.ATTR_GROUP_ID = AG_EXT.ATTR_GROUP_ID
657: AND NVL(ag_ext.VARIANT, 'N') = 'Y'
658: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'