View: IGC_CC_ENCMBRNC_CTRLS_V

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

View Text

SELECT ENC.ROWID ROW_ID
, ENC.ORG_ID
, ENC.CC_BUDGET_TYPE
, ENC.CC_PROV_ENCMBRNC_TYPE_ID
, GLE1.ENCUMBRANCE_TYPE CC_PROV_ENCMBRNC_TYPE
, ENC.CC_CONF_ENCMBRNC_TYPE_ID
, GLE2.ENCUMBRANCE_TYPE CC_CONF_ENCMBRNC_TYPE
, ENC.CC_PROV_ENCMBRNC_ENABLE_FLAG
, ENC.CC_CONF_ENCMBRNC_ENABLE_FLAG
, APF.REQ_ENCUMBRANCE_TYPE_ID AP_REQ_ENCMBRNC_TYPE_ID
, GLE3.ENCUMBRANCE_TYPE AP_REQ_ENCMBRNC_TYPE
, APF.PURCH_ENCUMBRANCE_TYPE_ID AP_PURCH_ENCMBRNC_TYPE_ID
, GLE4.ENCUMBRANCE_TYPE AP_PURCH_ENCMBRNC_TYPE
, APF.INV_ENCUMBRANCE_TYPE_ID AP_INV_ENCMBRNC_TYPE_ID
, GLE5.ENCUMBRANCE_TYPE AP_INV_ENCMBRNC_TYPE
, ENC.LAST_UPDATE_DATE
, ENC.LAST_UPDATED_BY
, ENC.LAST_UPDATE_LOGIN
, ENC.CREATION_DATE
, ENC.CREATED_BY
FROM IGC_CC_ENCMBRNC_CTRLS ENC
, FINANCIALS_SYSTEM_PARAMS_ALL APF
, GL_ENCUMBRANCE_TYPES GLE1
, GL_ENCUMBRANCE_TYPES GLE2
, GL_ENCUMBRANCE_TYPES GLE3
, GL_ENCUMBRANCE_TYPES GLE4
, GL_ENCUMBRANCE_TYPES GLE5
WHERE ENC.ORG_ID = APF.ORG_ID
AND ENC.CC_PROV_ENCMBRNC_TYPE_ID = GLE1.ENCUMBRANCE_TYPE_ID (+)
AND ENC.CC_CONF_ENCMBRNC_TYPE_ID = GLE2.ENCUMBRANCE_TYPE_ID (+)
AND APF.REQ_ENCUMBRANCE_TYPE_ID = GLE3.ENCUMBRANCE_TYPE_ID (+)
AND APF.PURCH_ENCUMBRANCE_TYPE_ID = GLE4.ENCUMBRANCE_TYPE_ID (+)
AND APF.INV_ENCUMBRANCE_TYPE_ID = GLE5.ENCUMBRANCE_TYPE_ID (+)

Columns