Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGCBV_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"
, CCEC.CC_PROV_ENCMBRNC_TYPE_ID PROVISIONAL_ENCMBRANCE_TYPE_ID
, CCEC.CC_CONF_ENCMBRNC_TYPE_ID CONFIRMED_ENCUMBRANCE_TYPE_ID
, ORU.NAME ORGANIZATION_NAME
, CCEC.CC_BUDGET_TYPE BUDGET_TYPE
, CCEC.ORG_ID ORGANIZATION_ID
, 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
, HR_ALL_ORGANIZATION_UNITS ORU
WHERE CCEC.ORG_ID=ORU.ORGANIZATION_ID
AND '_SEC:CCEC.ORG_ID' IS NOT NULL WITH READ ONLY