VIEW: APPS.AHL_PC_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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