Product: | BOM - Bills of Material |
---|---|
Description: | View for bill/routing alternates list of values - only enabled records |
Implementation/DBA Data: | APPS.BOM_ALT_DESIGNATORS_VAL_V |
SELECT BAD.ALTERNATE_DESIGNATOR_CODE
, BAD.DESCRIPTION
, BAD.DISABLE_DATE
, BAD.ORGANIZATION_ID
, BAD.LAST_UPDATE_DATE
, BAD.LAST_UPDATED_BY
, BAD.CREATION_DATE
, BAD.CREATED_BY
, BAD.LAST_UPDATE_LOGIN
, BAD.ATTRIBUTE_CATEGORY
, BAD.ATTRIBUTE1
, BAD.ATTRIBUTE2
, BAD.ATTRIBUTE3
, BAD.ATTRIBUTE4
, BAD.ATTRIBUTE5
, BAD.ATTRIBUTE6
, BAD.ATTRIBUTE7
, BAD.ATTRIBUTE8
, BAD.ATTRIBUTE9
, BAD.ATTRIBUTE10
, BAD.ATTRIBUTE11
, BAD.ATTRIBUTE12
, BAD.ATTRIBUTE13
, BAD.ATTRIBUTE14
, BAD.ATTRIBUTE15
, BAD.REQUEST_ID
, BAD.PROGRAM_APPLICATION_ID
, BAD.PROGRAM_ID
, BAD.PROGRAM_UPDATE_DATE
, BAD.STRUCTURE_TYPE_ID
, NVL(BST.ENABLE_UNIMPLEMENTED_BOMS
, 'N')
FROM BOM_ALTERNATE_DESIGNATORS BAD
, BOM_STRUCTURE_TYPES_B BST
WHERE TRUNC(NVL(BAD.DISABLE_DATE
, SYSDATE + 1)) > TRUNC(SYSDATE)
AND BAD.STRUCTURE_TYPE_ID = BST.STRUCTURE_TYPE_ID (+)
AND TRUNC(NVL(BST.DISABLE_DATE
, SYSDATE + 1)) > TRUNC(SYSDATE)