DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 426: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,

422: WHEN 'X' THEN To_Char(INTF.ATTR_VALUE_DATE)
423: WHEN 'Y' THEN To_Char(INTF.ATTR_VALUE_DATE)
424: END) ATTR_VALUE
425: FROM
426: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
427: EGO_FND_DF_COL_USGS_EXT ATTR_EXT,
428: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
429: EGO_ITM_USR_ATTR_INTRFC INTF
430: WHERE AG_EXT.APPLICATION_ID = ATTR_EXT.APPLICATION_ID

Line 588: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT,

584: attr_ext.attr_id,
585: l_login_id,
586: l_sysdate,
587: l_user_id
588: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
589: EGO_FND_DF_COL_USGS_EXT ATTR_EXT,
590: FND_DESCR_FLEX_COLUMN_USAGES FL_COL
591: WHERE AG_EXT.APPLICATION_ID = ATTR_EXT.APPLICATION_ID
592: AND AG_EXT.DESCRIPTIVE_FLEXFIELD_NAME = ATTR_EXT.DESCRIPTIVE_FLEXFIELD_NAME /* AG_TYPE*/

Line 639: EGO_FND_DSC_FLX_CTX_EXT ag_ext

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'
643: AND assoc.DATA_LEVEL_ID = l_item_data_level_id

Line 655: EGO_FND_DSC_FLX_CTX_EXT ag_ext

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'
659: AND assoc.DATA_LEVEL_ID = l_item_data_level_id