WIE_WO_SUPPLY_TYPES_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE DISPLAY_SEQUENCE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT fl.lookup_type lookup_type, fl.lookup_code lookup_code, fl.meaning meaning, fl.description description, fl.enabled_flag enabled_flag, fl.start_date_active start_date_active, fl.end_date_active end_date_active, fl.display_sequence display_sequence, fl.created_by created_by, fl.creation_date creation_date, fl.last_updated_by last_updated_by, fl.last_update_date last_update_date, fl.last_update_login last_update_login FROM fnd_lookups fl WHERE (fl.lookup_type = 'EGP_WIP_SUP_TYPE' and fl.lookup_code in ('1', '2', '3', '4', '5')) OR (fl.lookup_type = 'ORA_WIE_WO_SUPPLY_TYPE' and fl.lookup_code = '7')