FND Design Data [Home] [Help]

View: GMS_ENC_PSI_V

Product: GMS - Grants Accounting
Description:
Implementation/DBA Data: ViewAPPS.GMS_ENC_PSI_V
View Text

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
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' 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)
, GMS_COST_PLUS_EXTN.GET_AWARD_COMPILED_SET_ID('ENC'
, ET.ENCUMBRANCE_ITEM_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
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 ICC.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND ET.ENCUMBRANCE_ID = GE.ENCUMBRANCE_ID
AND ET.ENC_DISTRIBUTED_FLAG = 'Y'
AND CBET.EXPENDITURE_TYPE = ET.ENCUMBRANCE_TYPE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CM.IND_COMPILED_SET_ID = GMS_COST_PLUS_EXTN.GET_AWARD_COMPILED_SET_ID('ENC'
, ET.ENCUMBRANCE_ITEM_ID)
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

Columns

Name
PROJECT_ID
TASK_ID
TRANSACTION_SOURCE
LINE_TYPE
CMT_NUMBER
CMT_DISTRIBUTION_ID
CMT_HEADER_ID
DESCRIPTION
EXPENDITURE_ITEM_DATE
PA_PERIOD
GL_PERIOD
CMT_LINE_NUMBER
CMT_CREATION_DATE
CMT_APPROVED_DATE
CMT_REQUESTOR_NAME
CMT_BUYER_NAME
CMT_APPROVED_FLAG
CMT_PROMISED_DATE
CMT_NEED_BY_DATE
ORGANIZATION_ID
VENDOR_ID
VENDOR_NAME
EXPENDITURE_TYPE
EXPENDITURE_CATEGORY
REVENUE_CATEGORY
SYSTEM_LINKAGE_FUNCTION
UNIT_OF_MEASURE
UNIT_PRICE
CMT_IND_COMPILED_SET_ID
ACCT_RAW_COST
ACCT_BURDENED_COST
TOT_CMT_QUANTITY
QUANTITY_ORDERED
AMOUNT_ORDERED
ORIGINAL_QUANTITY_ORDERED
ORIGINAL_AMOUNT_ORDERED
QUANTITY_CANCELLED
AMOUNT_CANCELLED
QUANTITY_DELIVERED
QUANTITY_INVOICED
AMOUNT_INVOICED
QUANTITY_OUTSTANDING_DELIVERY
AMOUNT_OUTSTANDING_DELIVERY
QUANTITY_OUTSTANDING_INVOICE
AMOUNT_OUTSTANDING_INVOICE
QUANTITY_OVERBILLED
AMOUNT_OVERBILLED
ORIGINAL_TXN_REFERENCE1
ORIGINAL_TXN_REFERENCE2
ORIGINAL_TXN_REFERENCE3
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
DENOM_CURRENCY_CODE
DENOM_RAW_COST
DENOM_BURDENED_COST
ACCT_CURRENCY_CODE
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
RECEIPT_CURRENCY_CODE
RECEIPT_CURRENCY_AMOUNT
RECEIPT_EXCHANGE_RATE
ORG_ID