Product: | PA - Projects |
---|---|
Description: | Single-Org |
Implementation/DBA Data: | Not implemented in this database |
SELECT BC_COMMITMENT_ID
, PACKET_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, TRANSFERRED_DATE
, LIQUIDATE_GL_DATE
, PA_DATE
, GL_DATE
, TRANSFER_STATUS_CODE
, BURDEN_COST_FLAG
, PERIOD_NUM
, COMMITMENT_BATCH_NAME
, COMM_TRANSFER_REJ_REASON
, PROJECT_BATCH_NAME
, PROJ_TRANSFER_REJ_REASON
, JE_CATEGORY_NAME
, JE_SOURCE_NAME
, DOCUMENT_TYPE
, EXPENDITURE_ORGANIZATION_ID
, DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID
, PROCESS_EXP_ITEM_ID
, PROJ_ENCUMBRANCE_TYPE_ID
, ENCUMBRANCE_TYPE_ID
, PROCESS_CCID
, TOP_TASK_ID
, PARENT_RESOURCE_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID
, ENTERED_DR
, ENTERED_CR
, BUDGET_CCID
, BC_PACKET_ID
, PARENT_BC_PACKET_ID
, BUD_RESOURCE_LIST_MEMBER_ID
, BUD_TASK_ID
, REQUEST_ID
, ACTUAL_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID
, PERIOD_NAME
, PERIOD_YEAR
, TXN_CCID
, ACCOUNTED_CR
, ACCOUNTED_DR
, ORG_ID
, DOCUMENT_LINE_ID
, COMPILED_MULTIPLIER
, FC_START_DATE
, FC_END_DATE
, COMM_TOT_RAW_AMT
, COMM_TOT_BD_AMT
, COMM_RAW_AMT_RELIEVED
, COMM_BD_AMT_RELIEVED
, SUMMARY_RECORD_FLAG
, EXP_ITEM_ID
, REFERENCE1
, REFERENCE2
, REFERENCE3
FROM PA_BC_COMMITMENTS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)