View: AHL_PC_HEADERS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on AHL_PC_HEADERS_VL and FND_LOOKUPS
Implementation/DBA Data:	APPS.AHL_PC_HEADERS_V

View Text

SELECT AHPC.ROW_ID
, AHPC.PC_HEADER_ID
, AHPC.OBJECT_VERSION_NUMBER
, AHPC.LAST_UPDATE_DATE
, AHPC.LAST_UPDATED_BY
, AHPC.CREATION_DATE
, AHPC.CREATED_BY
, AHPC.LAST_UPDATE_LOGIN
, AHPC.NAME
, AHPC.STATUS
, ST.MEANING STATUS_DESC
, AHPC.PRODUCT_TYPE_CODE
, PT.MEANING PRODUCT_TYPE_DESC
, AHPC.PRIMARY_FLAG
, PFT.MEANING PRIMARY_FLAG_DESC
, AHPC.ASSOCIATION_TYPE_FLAG
, AT.MEANING ASSOCIATION_TYPE_DESC
, AHPC.DRAFT_FLAG
, AHPC.LINK_TO_PC_ID
, AHPC.DESCRIPTION
, AHPC.SECURITY_GROUP_ID
, AHPC.ATTRIBUTE_CATEGORY
, AHPC.ATTRIBUTE1
, AHPC.ATTRIBUTE2
, AHPC.ATTRIBUTE3
, AHPC.ATTRIBUTE4
, AHPC.ATTRIBUTE5
, AHPC.ATTRIBUTE6
, AHPC.ATTRIBUTE7
, AHPC.ATTRIBUTE8
, AHPC.ATTRIBUTE9
, AHPC.ATTRIBUTE10
, AHPC.ATTRIBUTE11
, AHPC.ATTRIBUTE12
, AHPC.ATTRIBUTE13
, AHPC.ATTRIBUTE14
, AHPC.ATTRIBUTE15
FROM AHL_PC_HEADERS_VL AHPC
, FND_LOOKUP_VALUES_VL PT
, FND_LOOKUP_VALUES_VL ST
, FND_LOOKUP_VALUES_VL AT
, FND_LOOKUP_VALUES_VL PFT
WHERE PT.LOOKUP_TYPE (+) = 'ITEM_TYPE'
AND PT.LOOKUP_CODE (+) = AHPC.PRODUCT_TYPE_CODE
AND PT.ENABLED_FLAG = 'Y'
AND PT.VIEW_APPLICATION_ID = 3
AND SYSDATE BETWEEN NVL(PT.START_DATE_ACTIVE
, SYSDATE)
AND NVL(PT.END_DATE_ACTIVE
, SYSDATE)
AND ST.LOOKUP_TYPE (+) = 'AHL_PC_STATUS'
AND ST.LOOKUP_CODE (+) = AHPC.STATUS
AND AT.LOOKUP_TYPE (+) = 'AHL_PC_ASSOS_TYPE'
AND AT.LOOKUP_CODE (+) = AHPC.ASSOCIATION_TYPE_FLAG
AND PFT.LOOKUP_TYPE (+) = 'AHL_YES_NO_TYPE'
AND PFT.LOOKUP_CODE (+) = AHPC.PRIMARY_FLAG

Columns