Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS |
SELECT '_LA:CC_PROV_ENCMBRNC_ENABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:PROV_ENCMBR_ENABLED_FLAG"
, '_LA:CC_CONF_ENCMBRNC_ENABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:CONF_ENCMBR_ENABLED_FLAG"
, GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE_NAME
, ORU.NAME ORGANIZATION_NAME
, CCEC.CC_PROV_ENCMBRNC_TYPE_ID PROVISIONAL_ENCUMBRNCE_TYPE_ID
, CCEC.CC_CONF_ENCMBRNC_TYPE_ID CONFIRMED_ENCUMBRNCE_TYPE_ID
, CCEC.ORG_ID ORGANIZATION_ID
, CCEC.CC_BUDGET_TYPE BUDGET_TYPE
, CCEC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCEC.LAST_UPDATED_BY LAST_UPDATED_BY
, CCEC.CREATION_DATE CREATION_DATE
, CCEC.CREATED_BY CREATED_BY
FROM IGC_CC_ENCMBRNC_CTRLS CCEC
, GL_ENCUMBRANCE_TYPES GL_ENCUMBRANCE_TYPES
, HR_ALL_ORGANIZATION_UNITS ORU
WHERE CCEC.CC_PROV_ENCMBRNC_TYPE_ID=GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE_ID (+)
AND CCEC.CC_CONF_ENCMBRNC_TYPE_ID=GL_ENCUMBRANCE_TYPES.ENCUMBRANCE_TYPE_ID (+)
AND CCEC.ORG_ID=ORU.ORGANIZATION_ID
AND '_SEC:CCEC.ORG_ID' IS NOT NULL WITH READ ONLY