eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGC_CC_ENCMBRNC_CTRLS_V

Source

View Text - Preformatted


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, ENC.SET_OF_BOOKS_ID 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 (+)

View Text - HTML Formatted

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
, ENC.SET_OF_BOOKS_ID
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 (+)