View: AHL_PC_ASSOCIATIONS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view contains info of Item/Unit associated to PC Node
Implementation/DBA Data:	APPS.AHL_PC_ASSOCIATIONS_V

View Text

SELECT AHS.ROWID ROW_ID
, AHS.PC_ASSOCIATION_ID
, AHS.OBJECT_VERSION_NUMBER
, AHS.LAST_UPDATE_DATE
, AHS.LAST_UPDATED_BY
, AHS.CREATION_DATE
, AHS.CREATED_BY
, AHS.LAST_UPDATE_LOGIN
, AHS.PC_NODE_ID
, AHS.UNIT_ITEM_ID
, MTL.CONCATENATED_SEGMENTS UNIT_ITEM_NAME
, MTL.DESCRIPTION UNIT_ITEM_DESCRIPTION
, AHS.ASSOCIATION_TYPE_FLAG
, AHS.LINK_TO_ASSOCIATION_ID
, AHS.DRAFT_FLAG
, AHS.OPERATION_STATUS_FLAG
, AHS.INVENTORY_ORG_ID
, '' SERIAL_NUMBER
, MTL.CONCATENATED_SEGMENTS ITEM_NUMBER
, MTL.ITEM_TYPE PRODUCT_TYPE
, AHS.SECURITY_GROUP_ID
, AHS.ATTRIBUTE_CATEGORY
, AHS.ATTRIBUTE1
, AHS.ATTRIBUTE2
, AHS.ATTRIBUTE3
, AHS.ATTRIBUTE4
, AHS.ATTRIBUTE5
, AHS.ATTRIBUTE6
, AHS.ATTRIBUTE7
, AHS.ATTRIBUTE8
, AHS.ATTRIBUTE9
, AHS.ATTRIBUTE10
, AHS.ATTRIBUTE11
, AHS.ATTRIBUTE12
, AHS.ATTRIBUTE13
, AHS.ATTRIBUTE14
, AHS.ATTRIBUTE15
FROM AHL_PC_ASSOCIATIONS AHS
, MTL_SYSTEM_ITEMS_KFV MTL
WHERE AHS.ASSOCIATION_TYPE_FLAG = 'I'
AND MTL.INVENTORY_ITEM_ID = AHS.UNIT_ITEM_ID
AND MTL.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID') UNION SELECT AHS.ROWID ROW_ID
, AHS.PC_ASSOCIATION_ID
, AHS.OBJECT_VERSION_NUMBER
, AHS.LAST_UPDATE_DATE
, AHS.LAST_UPDATED_BY
, AHS.CREATION_DATE
, AHS.CREATED_BY
, AHS.LAST_UPDATE_LOGIN
, AHS.PC_NODE_ID
, AHS.UNIT_ITEM_ID
, UNIT.NAME UNIT_ITEM_NAME
, MTL.DESCRIPTION UNIT_ITEM_DESCRIPTION
, AHS.ASSOCIATION_TYPE_FLAG
, AHS.LINK_TO_ASSOCIATION_ID
, AHS.DRAFT_FLAG
, AHS.OPERATION_STATUS_FLAG
, AHS.INVENTORY_ORG_ID
, CSI.SERIAL_NUMBER
, MTL.CONCATENATED_SEGMENTS ITEM_NUMBER
, MTL.ITEM_TYPE PRODUCT_TYPE
, AHS.SECURITY_GROUP_ID
, AHS.ATTRIBUTE_CATEGORY
, AHS.ATTRIBUTE1
, AHS.ATTRIBUTE2
, AHS.ATTRIBUTE3
, AHS.ATTRIBUTE4
, AHS.ATTRIBUTE5
, AHS.ATTRIBUTE6
, AHS.ATTRIBUTE7
, AHS.ATTRIBUTE8
, AHS.ATTRIBUTE9
, AHS.ATTRIBUTE10
, AHS.ATTRIBUTE11
, AHS.ATTRIBUTE12
, AHS.ATTRIBUTE13
, AHS.ATTRIBUTE14
, AHS.ATTRIBUTE15
FROM AHL_PC_ASSOCIATIONS AHS
, AHL_UNIT_CONFIG_HEADERS UNIT
, CSI_ITEM_INSTANCES CSI
, MTL_SYSTEM_ITEMS_KFV MTL
, AHL_PC_NODES_B NODE
, AHL_PC_HEADERS_B HEADER
WHERE AHS.ASSOCIATION_TYPE_FLAG = 'U'
AND UNIT.UNIT_CONFIG_HEADER_ID = AHS.UNIT_ITEM_ID
AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
AND HEADER.PRODUCT_TYPE_CODE = MTL.ITEM_TYPE
AND UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
AND CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND CSI.INV_MASTER_ORGANIZATION_ID = MTL.ORGANIZATION_ID

Columns