VIEW: APPS.PA_CC_DIST_LINES_ALL_MRC_V

Source

View Text - Preformatted

SELECT mc.acct_tp_exchange_rate ,mc.acct_tp_rate_date ,mc.acct_tp_rate_type ,mc.amount ,pa.bill_markup_percentage ,pa.bill_rate ,mc.cc_dist_line_id ,pa.cr_code_combination_id ,pa.created_by ,pa.creation_date ,pa.cross_charge_code ,pa.denom_tp_currency_code ,pa.denom_transfer_price ,pa.dist_line_id_reversed ,pa.dr_code_combination_id ,mc.expenditure_item_id ,mc.gl_batch_name ,pa.gl_date ,pa.ind_compiled_set_id ,pa.last_update_date ,pa.last_update_login ,pa.last_updated_by ,mc.line_num ,pa.line_num_reversed ,mc.line_type ,pa.markup_calc_base_code ,pa.org_id ,pa.pa_date ,mc.prc_assignment_id ,mc.program_application_id ,mc.program_id ,mc.program_update_date ,pa.project_id ,pa.reference_1 ,pa.reference_2 ,pa.reference_3 ,mc.request_id ,pa.reversed_flag ,pa.rule_percentage ,mc.set_of_books_id ,pa.schedule_line_percentage ,pa.task_id ,pa.tp_base_amount ,mc.transfer_rejection_code ,mc.transfer_status_code ,mc.transferred_date ,pa.GL_PERIOD_NAME ,pa.PA_PERIOD_NAME ,pa.PROJECT_TP_CURRENCY_CODE ,pa.PROJECT_TP_RATE_DATE ,pa.PROJECT_TP_RATE_TYPE ,pa.PROJECT_TP_EXCHANGE_RATE ,pa.PROJECT_TRANSFER_PRICE ,pa.PROJFUNC_TP_CURRENCY_CODE ,pa.PROJFUNC_TP_RATE_DATE ,pa.PROJFUNC_TP_RATE_TYPE ,pa.PROJFUNC_TP_EXCHANGE_RATE ,pa.PROJFUNC_TRANSFER_PRICE ,pa.TP_AMT_TYPE_CODE ,mc.acct_currency_code ,pa.acct_event_id FROM pa_cc_dist_lines_all pa, pa_mc_cc_dist_lines_all mc WHERE mc.expenditure_item_Id = pa.expenditure_item_id AND mc.prc_assignment_id = -99 AND mc.line_num = pa.line_num AND mc.line_type = pa.line_type AND mc.set_of_books_id = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10)), -99)

View Text - HTML Formatted

SELECT MC.ACCT_TP_EXCHANGE_RATE
, MC.ACCT_TP_RATE_DATE
, MC.ACCT_TP_RATE_TYPE
, MC.AMOUNT
, PA.BILL_MARKUP_PERCENTAGE
, PA.BILL_RATE
, MC.CC_DIST_LINE_ID
, PA.CR_CODE_COMBINATION_ID
, PA.CREATED_BY
, PA.CREATION_DATE
, PA.CROSS_CHARGE_CODE
, PA.DENOM_TP_CURRENCY_CODE
, PA.DENOM_TRANSFER_PRICE
, PA.DIST_LINE_ID_REVERSED
, PA.DR_CODE_COMBINATION_ID
, MC.EXPENDITURE_ITEM_ID
, MC.GL_BATCH_NAME
, PA.GL_DATE
, PA.IND_COMPILED_SET_ID
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATE_LOGIN
, PA.LAST_UPDATED_BY
, MC.LINE_NUM
, PA.LINE_NUM_REVERSED
, MC.LINE_TYPE
, PA.MARKUP_CALC_BASE_CODE
, PA.ORG_ID
, PA.PA_DATE
, MC.PRC_ASSIGNMENT_ID
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, PA.PROJECT_ID
, PA.REFERENCE_1
, PA.REFERENCE_2
, PA.REFERENCE_3
, MC.REQUEST_ID
, PA.REVERSED_FLAG
, PA.RULE_PERCENTAGE
, MC.SET_OF_BOOKS_ID
, PA.SCHEDULE_LINE_PERCENTAGE
, PA.TASK_ID
, PA.TP_BASE_AMOUNT
, MC.TRANSFER_REJECTION_CODE
, MC.TRANSFER_STATUS_CODE
, MC.TRANSFERRED_DATE
, PA.GL_PERIOD_NAME
, PA.PA_PERIOD_NAME
, PA.PROJECT_TP_CURRENCY_CODE
, PA.PROJECT_TP_RATE_DATE
, PA.PROJECT_TP_RATE_TYPE
, PA.PROJECT_TP_EXCHANGE_RATE
, PA.PROJECT_TRANSFER_PRICE
, PA.PROJFUNC_TP_CURRENCY_CODE
, PA.PROJFUNC_TP_RATE_DATE
, PA.PROJFUNC_TP_RATE_TYPE
, PA.PROJFUNC_TP_EXCHANGE_RATE
, PA.PROJFUNC_TRANSFER_PRICE
, PA.TP_AMT_TYPE_CODE
, MC.ACCT_CURRENCY_CODE
, PA.ACCT_EVENT_ID
FROM PA_CC_DIST_LINES_ALL PA
, PA_MC_CC_DIST_LINES_ALL MC
WHERE MC.EXPENDITURE_ITEM_ID = PA.EXPENDITURE_ITEM_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.LINE_NUM = PA.LINE_NUM
AND MC.LINE_TYPE = PA.LINE_TYPE
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10))
, -99)