[Home] [Help]
View: EDW_BRES_RESTYPE_LCV
Product: | ENG - Engineering |
Description: | This view holds the resource type information |
Implementation/DBA Data: |
APPS.EDW_BRES_RESTYPE_LCV
|
View Text
SELECT RT.MEANING
, INST.INSTANCE_CODE
, 'ALL'
, RT.MEANING
, RT.MEANING
, RT.MEANING
, RT.DESCRIPTION
, RT.LAST_UPDATE_DATE
, RT.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MFG_LOOKUPS RT
, EDW_LOCAL_INSTANCE INST
WHERE LOOKUP_TYPE='BOM_RESOURCE_TYPE' WITH READ ONLY
Columns
Name |
RESOURCE_TYPE_PK |
INSTANCE |
ALL_FK |
RESOURCE_TYPE_DP |
NAME |
RESOURCE_TYPE |
DESCRIPTION |
LAST_UPDATE_DATE |
CREATION_DATE |
OPERATION_CODE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |