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.GMS_ENC_PSI_V

Source

View Text - Preformatted


SELECT t.project_id, a.task_id, 'OUTSIDE_SYSTEM', 'N', c.encumbrance_group, line_num, a.encumbrance_item_id, to_char(NULL), a.encumbrance_item_date, pa_accum_utils.Get_current_pa_period, pa_accum_utils.Get_current_gl_period, to_number(NULL), a.creation_date, to_date(NULL), to_char(NULL), to_char(NULL), a.enc_distributed_flag, to_date(NULL), to_date(NULL), nvl(a.override_to_organization_id, c.incurred_by_organization_id), to_number(NULL), to_char(NULL), a.encumbrance_type, b.expenditure_category, b.revenue_category_code, a.system_linkage_function, to_char(NULL), to_number(NULL), to_number(NULL), pa_currency.round_currency_amt(a.amount), pa_currency.round_currency_amt(a.amount), to_number(null), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), a.attribute1, a.attribute6, NULL, to_date(NULL), to_number(NULL), SYSDATE, to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_date(NULL), a.denom_currency_code, pa_currency.round_currency_amt(a.amount), pa_currency.round_currency_amt(a.amount), a.acct_currency_code, a.acct_rate_date, a.acct_rate_type, a.acct_exchange_rate, null, to_number(null), to_number(null) , c.org_id, a.adjustment_type from gms_encumbrance_items_all a, gms_encumbrances c, pa_expenditure_types b , pa_tasks t WHERE a.encumbrance_type = b.expenditure_type and a.encumbrance_id = c.encumbrance_id and ( a.enc_distributed_flag = 'Y' or a.adjustment_type = 'BURDEN_RECALC') and a.task_id = t.task_id UNION ALL SELECT /*+ USE_NL(cbet, cm) */ t.project_id , et.task_id , 'OUTSIDE_SYSTEM', 'N', ge.encumbrance_group, et.line_num, et.encumbrance_item_id, to_char(NULL), et.encumbrance_item_date, pa_accum_utils.Get_current_pa_period, pa_accum_utils.Get_current_gl_period, to_number(NULL), et.creation_date, to_date(NULL), to_char(NULL), to_char(NULL), et.enc_distributed_flag, to_date(NULL), to_date(NULL), nvl(et.override_to_organization_id, ge.incurred_by_organization_id), to_number(NULL), to_char(NULL), icc.expenditure_type, pet.expenditure_category, pet.revenue_category_code, 'BTC', to_char(NULL), to_number(NULL), cm.ind_compiled_set_id, 0, pa_currency.round_currency_amt(nvl(gms_cost_plus_extn.get_burdenable_raw_cost('ENC', et.encumbrance_item_id),0) * cm.compiled_multiplier), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), et.attribute1, et.attribute6, NULL, to_date(NULL), to_number(NULL), SYSDATE, to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_number(NULL), to_date(NULL), et.denom_currency_code, 0, pa_currency.round_currency_amt(nvl(gms_cost_plus_extn.get_burdenable_raw_cost('ENC', et.encumbrance_item_id),0)*cm.compiled_multiplier), et.acct_currency_code, et.acct_rate_date, et.acct_rate_type, et.acct_exchange_rate, null, to_number(null), to_number(null) , ge.org_id, et.adjustment_type from gms_encumbrance_items et, pa_cost_base_exp_types cbet, pa_compiled_multipliers cm, pa_cost_base_cost_codes cbcc, pa_ind_cost_codes icc, gms_encumbrances ge, pa_expenditure_types pet, pa_tasks t WHERE pa_currency.round_currency_amt(nvl(gms_cost_plus_extn.get_burdenable_raw_cost('ENC', et.encumbrance_item_id),0)*cm.compiled_multiplier) <> 0 and icc.expenditure_type = pet.expenditure_type and et.encumbrance_id = ge.encumbrance_id and ( et.enc_distributed_flag = 'Y' or et.adjustment_type = 'BURDEN_RECALC') and cbet.expenditure_type = et.encumbrance_type and cbet.cost_base_type = 'INDIRECT COST' and cm.ind_compiled_set_id = (select ind_compiled_set_id from gms_award_distributions where expenditure_item_id = et.encumbrance_item_id and adl_status = 'A' and fc_status = 'A' and nvl(reversed_flag, 'N') <> 'Y' and line_num_reversed is null and document_type = 'ENC') and cbet.cost_base = cm.cost_base and icc.ind_cost_code = cm.ind_cost_code and cbcc.cost_base = cbet.cost_base and cbcc.cost_plus_structure = cbet.cost_plus_structure and cbcc.cost_base_type = cbet.cost_base_type and cbcc.ind_cost_code = cm.ind_cost_code and cbcc.cost_base_cost_code_id = cm.cost_base_cost_code_id and et.task_id = t.task_id

View Text - HTML Formatted

SELECT T.PROJECT_ID
, A.TASK_ID
, 'OUTSIDE_SYSTEM'
, 'N'
, C.ENCUMBRANCE_GROUP
, LINE_NUM
, A.ENCUMBRANCE_ITEM_ID
, TO_CHAR(NULL)
, A.ENCUMBRANCE_ITEM_DATE
, PA_ACCUM_UTILS.GET_CURRENT_PA_PERIOD
, PA_ACCUM_UTILS.GET_CURRENT_GL_PERIOD
, TO_NUMBER(NULL)
, A.CREATION_DATE
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, A.ENC_DISTRIBUTED_FLAG
, TO_DATE(NULL)
, TO_DATE(NULL)
, NVL(A.OVERRIDE_TO_ORGANIZATION_ID
, C.INCURRED_BY_ORGANIZATION_ID)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, A.ENCUMBRANCE_TYPE
, B.EXPENDITURE_CATEGORY
, B.REVENUE_CATEGORY_CODE
, A.SYSTEM_LINKAGE_FUNCTION
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PA_CURRENCY.ROUND_CURRENCY_AMT(A.AMOUNT)
, PA_CURRENCY.ROUND_CURRENCY_AMT(A.AMOUNT)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, A.ATTRIBUTE1
, A.ATTRIBUTE6
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, SYSDATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, A.DENOM_CURRENCY_CODE
, PA_CURRENCY.ROUND_CURRENCY_AMT(A.AMOUNT)
, PA_CURRENCY.ROUND_CURRENCY_AMT(A.AMOUNT)
, A.ACCT_CURRENCY_CODE
, A.ACCT_RATE_DATE
, A.ACCT_RATE_TYPE
, A.ACCT_EXCHANGE_RATE
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, C.ORG_ID
, A.ADJUSTMENT_TYPE
FROM GMS_ENCUMBRANCE_ITEMS_ALL A
, GMS_ENCUMBRANCES C
, PA_EXPENDITURE_TYPES B
, PA_TASKS T
WHERE A.ENCUMBRANCE_TYPE = B.EXPENDITURE_TYPE
AND A.ENCUMBRANCE_ID = C.ENCUMBRANCE_ID
AND ( A.ENC_DISTRIBUTED_FLAG = 'Y' OR A.ADJUSTMENT_TYPE = 'BURDEN_RECALC')
AND A.TASK_ID = T.TASK_ID UNION ALL SELECT /*+ USE_NL(CBET
, CM) */ T.PROJECT_ID
, ET.TASK_ID
, 'OUTSIDE_SYSTEM'
, 'N'
, GE.ENCUMBRANCE_GROUP
, ET.LINE_NUM
, ET.ENCUMBRANCE_ITEM_ID
, TO_CHAR(NULL)
, ET.ENCUMBRANCE_ITEM_DATE
, PA_ACCUM_UTILS.GET_CURRENT_PA_PERIOD
, PA_ACCUM_UTILS.GET_CURRENT_GL_PERIOD
, TO_NUMBER(NULL)
, ET.CREATION_DATE
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, ET.ENC_DISTRIBUTED_FLAG
, TO_DATE(NULL)
, TO_DATE(NULL)
, NVL(ET.OVERRIDE_TO_ORGANIZATION_ID
, GE.INCURRED_BY_ORGANIZATION_ID)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, ICC.EXPENDITURE_TYPE
, PET.EXPENDITURE_CATEGORY
, PET.REVENUE_CATEGORY_CODE
, 'BTC'
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, CM.IND_COMPILED_SET_ID
, 0
, PA_CURRENCY.ROUND_CURRENCY_AMT(NVL(GMS_COST_PLUS_EXTN.GET_BURDENABLE_RAW_COST('ENC'
, ET.ENCUMBRANCE_ITEM_ID)
, 0) * CM.COMPILED_MULTIPLIER)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, ET.ATTRIBUTE1
, ET.ATTRIBUTE6
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, SYSDATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, ET.DENOM_CURRENCY_CODE
, 0
, PA_CURRENCY.ROUND_CURRENCY_AMT(NVL(GMS_COST_PLUS_EXTN.GET_BURDENABLE_RAW_COST('ENC'
, ET.ENCUMBRANCE_ITEM_ID)
, 0)*CM.COMPILED_MULTIPLIER)
, ET.ACCT_CURRENCY_CODE
, ET.ACCT_RATE_DATE
, ET.ACCT_RATE_TYPE
, ET.ACCT_EXCHANGE_RATE
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, GE.ORG_ID
, ET.ADJUSTMENT_TYPE
FROM GMS_ENCUMBRANCE_ITEMS ET
, PA_COST_BASE_EXP_TYPES CBET
, PA_COMPILED_MULTIPLIERS CM
, PA_COST_BASE_COST_CODES CBCC
, PA_IND_COST_CODES ICC
, GMS_ENCUMBRANCES GE
, PA_EXPENDITURE_TYPES PET
, PA_TASKS T
WHERE PA_CURRENCY.ROUND_CURRENCY_AMT(NVL(GMS_COST_PLUS_EXTN.GET_BURDENABLE_RAW_COST('ENC'
, ET.ENCUMBRANCE_ITEM_ID)
, 0)*CM.COMPILED_MULTIPLIER) <> 0
AND ICC.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND ET.ENCUMBRANCE_ID = GE.ENCUMBRANCE_ID
AND ( ET.ENC_DISTRIBUTED_FLAG = 'Y' OR ET.ADJUSTMENT_TYPE = 'BURDEN_RECALC')
AND CBET.EXPENDITURE_TYPE = ET.ENCUMBRANCE_TYPE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CM.IND_COMPILED_SET_ID = (SELECT IND_COMPILED_SET_ID
FROM GMS_AWARD_DISTRIBUTIONS
WHERE EXPENDITURE_ITEM_ID = ET.ENCUMBRANCE_ITEM_ID
AND ADL_STATUS = 'A'
AND FC_STATUS = 'A'
AND NVL(REVERSED_FLAG
, 'N') <> 'Y'
AND LINE_NUM_REVERSED IS NULL
AND DOCUMENT_TYPE = 'ENC')
AND CBET.COST_BASE = CM.COST_BASE
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CBCC.COST_BASE = CBET.COST_BASE
AND CBCC.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CBCC.COST_BASE_TYPE = CBET.COST_BASE_TYPE
AND CBCC.IND_COST_CODE = CM.IND_COST_CODE
AND CBCC.COST_BASE_COST_CODE_ID = CM.COST_BASE_COST_CODE_ID
AND ET.TASK_ID = T.TASK_ID