View: IGC_CC_HEADERS_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CC_HEADERS_V

View Text

SELECT CCHD.ROWID
, CCHD.CC_HEADER_ID
, CCHD.ORG_ID
, L.MEANING
, CCHD.CC_TYPE
, CCHD.CC_NUM
, CCHD.CC_REF_NUM
, CCHD.CC_VERSION_NUM
, CCHD.CURRENCY_CODE
, SL.MEANING
, CCHD.CC_STATE
, ASL.MEANING
, CCHD.CC_APPRVL_STATUS
, CSL.MEANING
, CCHD.CC_CTRL_STATUS
, PV.VENDOR_NAME
, PV.SEGMENT1
, CCHD.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, CCHD.VENDOR_SITE_ID
, DECODE(CCHD.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME|| '
, ' || PVC.FIRST_NAME)
, CCHD.VENDOR_CONTACT_ID
, FNDU.USER_NAME
, CCHD.CC_PREPARER_USER_ID
, HR.FULL_NAME
, FNDU.EMPLOYEE_ID
, OFNDU.USER_NAME
, CCHD.CC_OWNER_USER_ID
, OHR.FULL_NAME
, OFNDU.EMPLOYEE_ID
, ATP.NAME
, CCHD.TERM_ID
, HRL.LOCATION_CODE
, CCHD.LOCATION_ID
, CCHD.CC_DESC
, CCHD.CC_ACCT_DATE
, CCHD.CC_START_DATE
, CCHD.CC_END_DATE
, CCHD.CONVERSION_TYPE
, CCHD.CONVERSION_DATE
, CCHD.CONVERSION_RATE
, CCHD.PARENT_HEADER_ID
, EL.MEANING
, CCHD.CC_ENCMBRNC_STATUS
, CCHD.SET_OF_BOOKS_ID
, PCCHD.CC_NUM
, PV.HOLD_FLAG
, CFNDU.USER_NAME
, CCHD.CC_CURRENT_USER_ID
, SUBSTR(IGC_CC_ACCESS_PKG.GET_ACCESS_LEVEL(CCHD.CC_HEADER_ID
, FND_GLOBAL.USER_ID
, CCHD.CC_PREPARER_USER_ID
, CCHD.CC_OWNER_USER_ID)
, 1
, 1)
, CCHD.WF_ITEM_TYPE
, CCHD.WF_ITEM_KEY
, CCHD.CONTEXT
, CCHD.ATTRIBUTE1
, CCHD.ATTRIBUTE2
, CCHD.ATTRIBUTE3
, CCHD.ATTRIBUTE4
, CCHD.ATTRIBUTE5
, CCHD.ATTRIBUTE6
, CCHD.ATTRIBUTE7
, CCHD.ATTRIBUTE8
, CCHD.ATTRIBUTE9
, CCHD.ATTRIBUTE10
, CCHD.ATTRIBUTE11
, CCHD.ATTRIBUTE12
, CCHD.ATTRIBUTE13
, CCHD.ATTRIBUTE14
, CCHD.ATTRIBUTE15
, CCHD.CREATED_BY
, CCHD.CREATION_DATE
, CCHD.LAST_UPDATED_BY
, CCHD.LAST_UPDATE_DATE
, CCHD.LAST_UPDATE_LOGIN
FROM IGC_CC_HEADERS CCHD
, FND_LOOKUPS L
, FND_LOOKUPS SL
, FND_LOOKUPS ASL
, FND_LOOKUPS CSL
, FND_LOOKUPS EL
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
, PO_VENDOR_CONTACTS PVC
, FND_USER FNDU
, HR_EMPLOYEES HR
, FND_USER OFNDU
, HR_EMPLOYEES OHR
, FND_USER CFNDU
, AP_TERMS ATP
, HR_LOCATIONS HRL
, GL_SETS_OF_BOOKS SOB
, IGC_CC_HEADERS PCCHD
WHERE SOB.SET_OF_BOOKS_ID (+) = CCHD.SET_OF_BOOKS_ID
AND L.LOOKUP_TYPE (+) = 'IGC_CC_TYPE'
AND L.LOOKUP_CODE (+) = CCHD.CC_TYPE
AND SL.LOOKUP_TYPE (+) = 'IGC_CC_STATE'
AND SL.LOOKUP_CODE (+) = CCHD.CC_STATE
AND ASL.LOOKUP_TYPE (+) = 'IGC_CC_APPROVAL_STATUS'
AND ASL.LOOKUP_CODE (+) = CCHD.CC_APPRVL_STATUS
AND CSL.LOOKUP_TYPE (+) = 'IGC_CC_CONTROL_STATUS'
AND CSL.LOOKUP_CODE (+) = CCHD.CC_CTRL_STATUS
AND EL.LOOKUP_TYPE (+) = 'IGC_CC_ENCUMBRANCE_STATUS'
AND EL.LOOKUP_CODE (+) = CCHD.CC_ENCMBRNC_STATUS
AND PV.VENDOR_ID (+) = CCHD.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+) = CCHD.VENDOR_SITE_ID
AND PVC.VENDOR_CONTACT_ID (+) = CCHD.VENDOR_CONTACT_ID
AND FNDU.USER_ID (+) = CCHD.CC_PREPARER_USER_ID
AND HR.EMPLOYEE_ID (+) = FNDU.EMPLOYEE_ID
AND OFNDU.USER_ID (+) = CCHD.CC_OWNER_USER_ID
AND OHR.EMPLOYEE_ID (+) = OFNDU.EMPLOYEE_ID
AND CFNDU.USER_ID (+) = CCHD.CC_CURRENT_USER_ID
AND ATP.TERM_ID (+) = CCHD.TERM_ID
AND HRL.LOCATION_ID (+) = CCHD.LOCATION_ID
AND PCCHD.CC_HEADER_ID (+) = CCHD.PARENT_HEADER_ID
AND IGC_CC_ACCESS_PKG.GET_ACCESS_LEVEL(CCHD.CC_HEADER_ID
, FND_GLOBAL.USER_ID
, CCHD.CC_PREPARER_USER_ID
, CCHD.CC_OWNER_USER_ID) IN ('M'
, 'R')

Columns