[Home] [Help]
View: BOM_STD_OP_SCRAP_CODES_V
Product: | BOM - Bills of Material |
Description: | Displays information about scrap codes for a standard operation |
Implementation/DBA Data: |
APPS.BOM_STD_OP_SCRAP_CODES_V
|
View Text
SELECT BSC.ROWID ROW_ID
, BSC.STANDARD_OPERATION_ID
, BSC.SEQUENCE_NUM
, BSC.SCRAP_CODE
, ML.MEANING
, BSC.MAX_ACCEPTABLE_SCRAP_QTY
, ML.DESCRIPTION
, BSC.LAST_UPDATE_DATE
, BSC.LAST_UPDATED_BY
, BSC.CREATION_DATE
, BSC.CREATED_BY
, BSC.LAST_UPDATE_LOGIN
FROM BOM_STD_OP_SCRAP_CODES BSC
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE = 'BOM_SCRAP_CODES'
AND ML.LOOKUP_CODE = BSC.SCRAP_CODE
Columns
Name |
ROW_ID |
STANDARD_OPERATION_ID |
SEQUENCE_NUM |
SCRAP_CODE |
MEANING |
MAX_ACCEPTABLE_SCRAP_QTY |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |