[Home] [Help]
View: BOM_RESOURCE_DOWNCODES_V
Product: | BOM - Bills of Material |
Description: | View based on Table BOM_RESOURCE_DOWNCODES for Defining Down Codes |
Implementation/DBA Data: |
APPS.BOM_RESOURCE_DOWNCODES_V
|
View Text
SELECT BRD.ROWID ROW_ID
, BRD.RESOURCE_ID
, BRD.DOWNCODE
, ML.MEANING
, ML.DESCRIPTION
, BRD.LAST_UPDATE_DATE
, BRD.LAST_UPDATED_BY
, BRD.CREATION_DATE
, BRD.CREATED_BY
, BRD.LAST_UPDATE_LOGIN
FROM BOM_RESOURCE_DOWNCODES BRD
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_CODE = BRD.DOWNCODE
AND ML.LOOKUP_TYPE = 'BOM_RESOURCE_DOWNCODES'
Columns
Name |
ROW_ID |
RESOURCE_ID |
DOWNCODE |
MEANING |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |