VIEW: APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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