VIEW: APPS.BOM_STD_OP_BONUS_CODES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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