VIEW: APPS.BOM_ALT_DESIGNATORS_VAL_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)