[Home] [Help]
View: BOM_STD_OP_BONUS_CODES_V
Product: | BOM - Bills of Material |
Description: | Displays the bonus codes of a standard operation |
Implementation/DBA Data: |
APPS.BOM_STD_OP_BONUS_CODES_V
|
View Text
SELECT BBC.ROWID ROW_ID
, BBC.STANDARD_OPERATION_ID
, BBC.SEQUENCE_NUMBER
, BBC.BONUS_CODE
, ML.MEANING
, ML.DESCRIPTION
, BBC.LAST_UPDATE_DATE
, BBC.LAST_UPDATED_BY
, BBC.CREATION_DATE
, BBC.CREATED_BY
, BBC.LAST_UPDATE_LOGIN
FROM BOM_STD_OP_BONUS_CODES BBC
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE = 'BOM_BONUS_CODES'
AND ML.LOOKUP_CODE = BBC.BONUS_CODE
Columns
Name |
ROW_ID |
STANDARD_OPERATION_ID |
SEQUENCE_NUMBER |
BONUS_CODE |
MEANING |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |