DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 490: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,

486: WHEN 'X' THEN To_Char(INTF.ATTR_VALUE_DATE)
487: WHEN 'Y' THEN To_Char(INTF.ATTR_VALUE_DATE)
488: END) ATTR_VALUE
489: FROM
490: EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
491: EGO_FND_DF_COL_USGS_EXT ATTR_EXT,
492: FND_DESCR_FLEX_COLUMN_USAGES FL_COL,
493: EGO_ITM_USR_ATTR_INTRFC INTF
494: WHERE AG_EXT.APPLICATION_ID = ATTR_EXT.APPLICATION_ID

Line 652: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT,

648: attr_ext.attr_id,
649: l_login_id,
650: l_sysdate,
651: l_user_id
652: FROM EGO_FND_DSC_FLX_CTX_EXT AG_EXT,
653: EGO_FND_DF_COL_USGS_EXT ATTR_EXT,
654: FND_DESCR_FLEX_COLUMN_USAGES FL_COL
655: WHERE AG_EXT.APPLICATION_ID = ATTR_EXT.APPLICATION_ID
656: AND AG_EXT.DESCRIPTIVE_FLEXFIELD_NAME = ATTR_EXT.DESCRIPTIVE_FLEXFIELD_NAME /* AG_TYPE*/

Line 703: EGO_FND_DSC_FLX_CTX_EXT ag_ext

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'
707: AND assoc.DATA_LEVEL_ID = g_ego_item_data_level_id

Line 719: EGO_FND_DSC_FLX_CTX_EXT ag_ext

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'
723: AND assoc.DATA_LEVEL_ID = g_ego_item_data_level_id