Product: | BOM - Bills of Material |
---|---|
Description: | Component and operations to be deleted |
Implementation/DBA Data: | APPS.BOM_DELETE_SUB_ENTITIES_V |
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'