Product: | BOM - Bills of Material |
---|---|
Description: | Deleted entities in BOM and INV |
Implementation/DBA Data: | APPS.BOM_DELETE_ENTITIES_V |
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