View: BOM_DELETE_ENTITIES_V

Product:	BOM - Bills of Material
Description:	Deleted entities in BOM and INV
Implementation/DBA Data:	APPS.BOM_DELETE_ENTITIES_V

View Text

SELECT BDE.ROWID ROW_ID
, BDE.DELETE_ENTITY_SEQUENCE_ID
, BDE.DELETE_GROUP_SEQUENCE_ID
, BDE.DELETE_ENTITY_TYPE
, ML1.MEANING DELETE_ENTITY
, BDE.BILL_SEQUENCE_ID
, BDE.ROUTING_SEQUENCE_ID
, BDE.INVENTORY_ITEM_ID
, BDE.ORGANIZATION_ID
, BDE.ALTERNATE_DESIGNATOR
, BDE.ITEM_DESCRIPTION
, BDE.ITEM_CONCAT_SEGMENTS
, BDE.DELETE_STATUS_TYPE
, ML2.MEANING DELETE_STATUS
, BDE.DELETE_DATE
, BDE.PRIOR_PROCESS_FLAG
, BDE.PRIOR_COMMIT_FLAG
, BDE.LAST_UPDATE_DATE
, BDE.LAST_UPDATED_BY
, BDE.CREATION_DATE
, BDE.CREATED_BY
, BDE.LAST_UPDATE_LOGIN
, BDE.REQUEST_ID
, BDE.PROGRAM_APPLICATION_ID
, BDE.PROGRAM_ID
, BDE.PROGRAM_UPDATE_DATE
, MP.ORGANIZATION_CODE
FROM BOM_DELETE_ENTITIES BDE
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MTL_PARAMETERS MP
WHERE BDE.DELETE_ENTITY_TYPE = ML1.LOOKUP_CODE (+)
AND ML1.LOOKUP_TYPE (+) = 'BOM_DELETE_ENTITY_TYPE'
AND BDE.DELETE_STATUS_TYPE = ML2.LOOKUP_CODE (+)
AND ML2.LOOKUP_TYPE (+) = 'BOM_DELETE_STATUS_TYPE'
AND BDE.ORGANIZATION_ID = MP.ORGANIZATION_ID

Columns