View: BOM_BILL_OF_MATERIALS

Product:	BOM - Bills of Material
Description:	Bill of materials view
Implementation/DBA Data:	APPS.BOM_BILL_OF_MATERIALS

View Text

SELECT ASSEMBLY_ITEM_ID
, ORGANIZATION_ID
, ALTERNATE_BOM_DESIGNATOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMMON_ASSEMBLY_ITEM_ID
, SPECIFIC_ASSEMBLY_COMMENT
, PENDING_FROM_ECN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ASSEMBLY_TYPE
, COMMON_BILL_SEQUENCE_ID
, BILL_SEQUENCE_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, COMMON_ORGANIZATION_ID
, NEXT_EXPLODE_DATE
, PROJECT_ID
, TASK_ID
, ORIGINAL_SYSTEM_REFERENCE
, STRUCTURE_TYPE_ID
, IMPLEMENTATION_DATE
, OBJ_NAME
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, EFFECTIVITY_CONTROL
, IS_PREFERRED
, SOURCE_BILL_SEQUENCE_ID
FROM BOM_STRUCTURES_B
WHERE ( OBJ_NAME IS NULL
AND FND_GLOBAL.RESP_APPL_ID = 431 ) OR ( OBJ_NAME IS NULL
AND FND_GLOBAL.RESP_APPL_ID = -1 ) OR ( OBJ_NAME IS NULL
AND FND_GLOBAL.RESP_APPL_ID != 431
AND NVL(EFFECTIVITY_CONTROL
, 1) <= 3 )

Columns