APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 510: FROM EGO_OBJ_AG_ASSOCS_B a

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

Line 664: FROM EGO_OBJ_AG_ASSOCS_B a

660: AND ATTR_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE /* AG_NAME*/
661: AND ATTR_EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME /* DATABASE_COLUMN */
662: AND AG_EXT.VARIANT = 'Y'
663: AND AG_EXT.ATTR_GROUP_ID IN (SELECT A.ATTR_GROUP_ID
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

Line 702: EGO_OBJ_AG_ASSOCS_B assoc,

698:
699: CURSOR c_existing_variants IS
700: SELECT assoc.ATTR_GROUP_ID
701: FROM
702: EGO_OBJ_AG_ASSOCS_B assoc,
703: EGO_FND_DSC_FLX_CTX_EXT ag_ext
704: WHERE assoc.ATTR_GROUP_ID = AG_EXT.ATTR_GROUP_ID
705: AND NVL(ag_ext.VARIANT, 'N') = 'Y'
706: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'

Line 718: EGO_OBJ_AG_ASSOCS_B assoc,

714:
715: CURSOR c_new_variants IS
716: SELECT assoc.ATTR_GROUP_ID
717: FROM
718: EGO_OBJ_AG_ASSOCS_B assoc,
719: EGO_FND_DSC_FLX_CTX_EXT ag_ext
720: WHERE assoc.ATTR_GROUP_ID = AG_EXT.ATTR_GROUP_ID
721: AND NVL(ag_ext.VARIANT, 'N') = 'Y'
722: AND NVL(assoc.ENABLED_FLAG, 'Y') = 'Y'