VIEW: APPS.BOM_DELETE_SUB_ENTITIES_V

Source

View Text - Preformatted

SELECT BDSE.ROWID ROW_ID , BDSE.DELETE_ENTITY_SEQUENCE_ID , BDSE.COMPONENT_SEQUENCE_ID , BDSE.OPERATION_SEQUENCE_ID , BDSE.OPERATION_SEQ_NUM , BDSE.EFFECTIVITY_DATE , BDSE.COMPONENT_ITEM_ID , BDSE.COMPONENT_CONCAT_SEGMENTS , BDSE.ITEM_NUM , BDSE.DISABLE_DATE , BDSE.DESCRIPTION , BDSE.OPERATION_DEPARTMENT_CODE , BDSE.DELETE_STATUS_TYPE , ML.MEANING DELETE_STATUS , BDSE.DELETE_DATE , BDSE.LAST_UPDATE_DATE , BDSE.LAST_UPDATED_BY , BDSE.CREATION_DATE , BDSE.CREATED_BY , BDSE.LAST_UPDATE_LOGIN , BDSE.REQUEST_ID , BDSE.PROGRAM_APPLICATION_ID , BDSE.PROGRAM_ID , BDSE.PROGRAM_UPDATE_DATE , BDSE.FROM_END_ITEM_UNIT_NUMBER , BDSE.TO_END_ITEM_UNIT_NUMBER FROM BOM_DELETE_SUB_ENTITIES BDSE , MFG_LOOKUPS ML WHERE BDSE.DELETE_STATUS_TYPE (+) = ML.LOOKUP_CODE AND ML.LOOKUP_TYPE = 'BOM_DELETE_STATUS_TYPE'

View Text - HTML Formatted

SELECT BDSE.ROWID ROW_ID
, BDSE.DELETE_ENTITY_SEQUENCE_ID
, BDSE.COMPONENT_SEQUENCE_ID
, BDSE.OPERATION_SEQUENCE_ID
, BDSE.OPERATION_SEQ_NUM
, BDSE.EFFECTIVITY_DATE
, BDSE.COMPONENT_ITEM_ID
, BDSE.COMPONENT_CONCAT_SEGMENTS
, BDSE.ITEM_NUM
, BDSE.DISABLE_DATE
, BDSE.DESCRIPTION
, BDSE.OPERATION_DEPARTMENT_CODE
, BDSE.DELETE_STATUS_TYPE
, ML.MEANING DELETE_STATUS
, BDSE.DELETE_DATE
, BDSE.LAST_UPDATE_DATE
, BDSE.LAST_UPDATED_BY
, BDSE.CREATION_DATE
, BDSE.CREATED_BY
, BDSE.LAST_UPDATE_LOGIN
, BDSE.REQUEST_ID
, BDSE.PROGRAM_APPLICATION_ID
, BDSE.PROGRAM_ID
, BDSE.PROGRAM_UPDATE_DATE
, BDSE.FROM_END_ITEM_UNIT_NUMBER
, BDSE.TO_END_ITEM_UNIT_NUMBER
FROM BOM_DELETE_SUB_ENTITIES BDSE
, MFG_LOOKUPS ML
WHERE BDSE.DELETE_STATUS_TYPE (+) = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'BOM_DELETE_STATUS_TYPE'