Project Cost Distribution only Accepted TRANSFER_STATUS_CODE (PA_COST_DISTRIBUTION_LINES_ALL & PA_EXPENDITURE_ITEMS_ALL )

SELECT
PEI.VENDOR_ID,
ASP.SEGMENT1 VENDOR_NO,
ASP.VENDOR_NAME,
PEV.PROJECT_NUMBER,PEV.PROJECT_NAME ,PCE.PROJECT_ID,
PEV.TASK_NUMBER,PEV.TASK_NAME,
PEV.PROJECT_TYPE,
PEV.EMPLOYEE_NAME,
PEV.EXPENDITURE_ITEM_DATE,
PEV.EXPENDITURE_TYPE,
PEV.EXPENDITURE_CATEGORY,
PEV.EXPENDITURE_COMMENT,
PEV.TRANSACTION_SOURCE,
PEV.EXPENDITURE_GROUP,
PEV.EXPENDITURE_STATUS_CODE,
PEV.COST_DISTRIBUTED_FLAG,
PEV.TRANSFERRED_FROM_EXP_ITEM_ID,
PEV.TRANSFERRED_ITEM_FLAG,
PEV.LAST_UPDATE_DATE,
PEV.LAST_UPDATE_DATE,
PEV.ALLOW_ADJUSTMENTS_FLAG,
PEV.COSTED_FLAG,
PEV.COST_BURDENED_FLAG,
PEV.GL_ACCOUNTED_FLAG,
PEV.USER_TRANSACTION_SOURCE,
PEV.ORIG_EXP_TXN_REFERENCE1,
PEV.ORIG_USER_EXP_TXN_REFERENCE,
PEV.ORIG_EXP_TXN_REFERENCE2,
PEV.LATEST_PA_DATE,
PEV.LATEST_GL_DATE,
PEV.DOCUMENT_HEADER_ID,
PEV.DOCUMENT_DISTRIBUTION_ID,
PEV.DOCUMENT_TYPE,

PCE.DR_CODE_COMBINATION_ID,
(select CONCATENATED_SEGMENTS from GL_CODE_COMBINATIONS_KFV where CODE_COMBINATION_ID=PCE.DR_CODE_COMBINATION_ID) Debit_ACCOUNT,
PCE.CR_CODE_COMBINATION_ID,
(select CONCATENATED_SEGMENTS from GL_CODE_COMBINATIONS_KFV where CODE_COMBINATION_ID=PCE.CR_CODE_COMBINATION_ID) Credit_ACCOUNT,

PCE.EXPENDITURE_ITEM_ID, PCE.LINE_NUM, PCE.CREATION_DATE, PCE.CREATED_BY, PCE.TRANSFER_STATUS_CODE, PCE.AMOUNT, PCE.QUANTITY, PCE.BILLABLE_FLAG, PCE.REQUEST_ID,
PCE.PROGRAM_APPLICATION_ID, PCE.PROGRAM_ID, PCE.PROGRAM_UPDATE_DATE, PCE.PA_DATE,PCE.GL_DATE, PCE.TRANSFERRED_DATE, PCE.TRANSFER_REJECTION_REASON,
PCE.BATCH_NAME, PCE.ACCUMULATED_FLAG, PCE.REVERSED_FLAG, PCE.LINE_NUM_REVERSED, PCE.SYSTEM_REFERENCE1, PCE.SYSTEM_REFERENCE2, PCE.SYSTEM_REFERENCE3,
PCE.IND_COMPILED_SET_ID, PCE.LINE_TYPE, PCE.BURDENED_COST, PCE.RESOURCE_ACCUMULATED_FLAG, PCE.FUNCTION_TRANSACTION_CODE, PCE.ORG_ID, PCE.CODE_COMBINATION_ID, PCE.BURDEN_SUM_SOURCE_RUN_ID,
PCE.BURDEN_SUM_REJECTION_CODE, PCE.DENOM_CURRENCY_CODE, PCE.DENOM_RAW_COST, PCE.DENOM_BURDENED_COST, PCE.ACCT_CURRENCY_CODE, PCE.ACCT_RATE_DATE, PCE.ACCT_RATE_TYPE, PCE.ACCT_EXCHANGE_RATE,
PCE.ACCT_RAW_COST, PCE.ACCT_BURDENED_COST, PCE.PROJECT_CURRENCY_CODE, PCE.PROJECT_RATE_DATE, PCE.PROJECT_RATE_TYPE, PCE.PROJECT_EXCHANGE_RATE, PCE.PROJECT_ID, PCE.TASK_ID, PCE.PRC_GENERATED_FLAG,
PCE.RECVR_PA_DATE, PCE.RECVR_GL_DATE, PCE.UTIL_SUMMARIZED_FLAG, PCE.LIQUIDATE_ENCUM_FLAG, PCE.ENCUMBRANCE_BATCH_NAME, PCE.ENCUMBRANCE_TYPE_ID, PCE.ENCUM_TRANSFER_REJ_REASON, PCE.BUDGET_CCID,
PCE.ENCUMBRANCE_AMOUNT, PCE.PROJFUNC_COST_EXCHANGE_RATE, PCE.PROJECT_RAW_COST, PCE.PROJECT_BURDENED_COST, PCE.WORK_TYPE_ID, PCE.GL_PERIOD_NAME, PCE.RECVR_GL_PERIOD_NAME, PCE.PA_PERIOD_NAME,
PCE.PROJFUNC_COST_RATE_TYPE, PCE.PROJFUNC_COST_RATE_DATE, PCE.RECVR_PA_PERIOD_NAME, PCE.PROJFUNC_CURRENCY_CODE, PCE.SYSTEM_REFERENCE4, PCE.PJI_SUMMARIZED_FLAG, PCE.ORG_LABOR_SCH_RULE_ID,
PCE.COST_RATE_SCH_ID, PCE.DENOM_BURDENED_CHANGE, PCE.PROJECT_BURDENED_CHANGE, PCE.PROJFUNC_BURDENED_CHANGE, PCE.ACCT_BURDENED_CHANGE, PCE.PARENT_LINE_NUM, PCE.PREV_IND_COMPILED_SET_ID,
PCE.SI_ASSETS_ADDITION_FLAG, PCE.SYSTEM_REFERENCE5, PCE.ACCT_EVENT_ID, PCE.ACCT_SOURCE_CODE, PCE.BUDGET_LINE_ID, PCE.BUDGET_VERSION_ID, PCE.LEGAL_ENTITY_ID, PCE.RECEIVER_LEGAL_ENTITY_ID

FROM PA_COST_DISTRIBUTION_LINES_ALL PCE, PA_EXPENDITURE_ITEMS_ALL PEI, PA_EXPEND_ITEMS_ADJUST2_V PEV, AP_SUPPLIERS ASP
WHERE 1=1
--and PCE.PROJECT_ID=31009 AND PEI.VENDOR_ID=213280
AND PCE.EXPENDITURE_ITEM_ID=PEI.EXPENDITURE_ITEM_ID
AND PCE.EXPENDITURE_ITEM_ID=PEV.EXPENDITURE_ITEM_ID
and PCE.TRANSFER_STATUS_CODE='A'
and trunc(PCE.GL_DATE) between '01-JAN-16'and '01-DEC-16'
AND PEI.VENDOR_ID=ASP.VENDOR_ID