VIEW: APPS.BOM_BILL_OF_MATERIALS

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )