View: AHL_ITEM_COMP_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	Item Composition V joins Lookup meaning and Codes and MTL table for Item Name
Implementation/DBA Data:	APPS.AHL_ITEM_COMP_V

View Text

SELECT ICB.ROWID ROW_ID
, ICB.ITEM_COMPOSITION_ID
, ICB.INVENTORY_ITEM_ID
, ICB.INVENTORY_MASTER_ORG_ID
, ICB.DRAFT_FLAG
, DECODE( SIGN(TRUNC(NVL(ICB.EFFECTIVE_END_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, ICB.APPROVAL_STATUS_CODE
, 'EXPIRED' ) APPROVAL_STATUS_CODE
, FND.MEANING APPROVAL_STATUS_MEANING
, FND.DESCRIPTION APPROVAL_STATUS_DESC
, MTL.ORGANIZATION_NAME ORGANIZATION_NAME
, MTL.ORGANIZATION_CODE ORGANIZATION_CODE
, MTL.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, MTL.DESCRIPTION DESCRIPTION
, ICB.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ICB.LINK_COMP_ID LINK_COMP_ID
, ICB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ICB.LAST_UPDATED_BY LAST_UPDATED_BY
, ICB.CREATION_DATE CREATION_DATE
, ICB.CREATED_BY CREATED_BY
, ICB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ICB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ICB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, ICB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ICB.ATTRIBUTE1 ATTRIBUTE1
, ICB.ATTRIBUTE2 ATTRIBUTE2
, ICB.ATTRIBUTE3 ATTRIBUTE3
, ICB.ATTRIBUTE4 ATTRIBUTE4
, ICB.ATTRIBUTE5 ATTRIBUTE5
, ICB.ATTRIBUTE6 ATTRIBUTE6
, ICB.ATTRIBUTE7 ATTRIBUTE7
, ICB.ATTRIBUTE8 ATTRIBUTE8
, ICB.ATTRIBUTE9 ATTRIBUTE9
, ICB.ATTRIBUTE10 ATTRIBUTE10
, ICB.ATTRIBUTE11 ATTRIBUTE11
, ICB.ATTRIBUTE12 ATTRIBUTE12
, ICB.ATTRIBUTE13 ATTRIBUTE13
, ICB.ATTRIBUTE14 ATTRIBUTE14
, ICB.ATTRIBUTE15 ATTRIBUTE15
FROM FND_LOOKUP_VALUES_VL FND
, AHL_MTL_ITEMS_NON_OU_V MTL
, AHL_ITEM_COMPOSITIONS ICB
WHERE FND.LOOKUP_CODE =DECODE(SIGN(TRUNC(NVL(ICB.EFFECTIVE_END_DATE
, SYSDATE+1)) - TRUNC(SYSDATE))
, 1
, ICB.APPROVAL_STATUS_CODE
, 'EXPIRED' )
AND FND.LOOKUP_TYPE (+) = 'AHL_ITEM_COMPOSITION_STATUS'
AND ICB.INVENTORY_ITEM_ID= MTL.INVENTORY_ITEM_ID
AND ICB.INVENTORY_MASTER_ORG_ID = MTL.INVENTORY_ORG_ID

Columns