VIEW: APPS.PA_CUST_EVENT_RDL_ALL_MRC_V2

Source

View Text - Preformatted

SELECT mc.PROJECT_ID , mc.TASK_ID , mc.EVENT_NUM , mc.LINE_NUM , mc.AMOUNT , mc.REQUEST_ID , mc.PROGRAM_APPLICATION_ID , mc.PROGRAM_ID , mc.PROGRAM_UPDATE_DATE , mc.BATCH_NAME , mc.DRAFT_REVENUE_NUM , mc.DRAFT_REVENUE_ITEM_LINE_NUM , mc.DRAFT_INVOICE_NUM , mc.DRAFT_INVOICE_ITEM_LINE_NUM , pa.CREATION_DATE, pa.CREATED_BY, pa.CODE_COMBINATION_ID, pa.LINE_NUM_REVERSED, pa.REVERSED_FLAG, pa.OUTPUT_VAT_TAX_ID, pa.OUTPUT_TAX_CLASSIFICATION_CODE, pa.OUTPUT_TAX_EXEMPT_FLAG, pa.OUTPUT_TAX_EXEMPT_REASON_CODE, pa.OUTPUT_TAX_EXEMPT_NUMBER, pa.PRC_GENERATED_FLAG, pa.ORG_ID, mc.currency_code, mc.amount, mc.amount, mc.exchange_rate, mc.conversion_date, mc.rate_type, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(MC.RATE_TYPE), mc.rate_type, mc.conversion_date, mc.exchange_rate, pa.bill_trans_currency_code, pa.bill_trans_amount, pa.revproc_currency_code, pa.revproc_rate_type, pa.revproc_rate_date, pa.revproc_exchange_rate, pa.invproc_currency_code, pa.invproc_rate_type, pa.invproc_rate_date, pa.invproc_exchange_rate, pa.project_currency_code, C1.USER_CONVERSION_TYPE PROJECT_REV_RATE_TYPE, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(pa.PROJECT_REV_RATE_TYPE), pa.project_rev_rate_date, pa.project_rev_exchange_rate, pa.project_revenue_amount, pa.project_inv_rate_type, pa.project_inv_rate_date, pa.project_inv_exchange_rate, pa.project_bill_amount, pa.funding_currency_code, C2.USER_CONVERSION_TYPE FUNDING_REV_RATE_TYPE, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(pa.FUNDING_REV_RATE_TYPE), pa.funding_rev_rate_date, pa.funding_rev_exchange_rate, pa.funding_revenue_amount, pa.funding_inv_rate_type, pa.funding_inv_rate_date, pa.funding_inv_exchange_rate, pa.funding_bill_amount ,pa.retention_rule_id ,pa.retn_draft_invoice_num ,pa.retn_draft_invoice_line_num ,pa.retained_amount ,pa.inv_gen_rejection_code FROM PA_CUST_EVENT_RDL_ALL pa, PA_MC_CUST_EVENT_RDL_ALL mc, PA_CONVERSION_TYPES_V C1, PA_CONVERSION_TYPES_V C2 WHERE mc.project_id = pa.project_id AND mc.event_num = pa.event_num AND mc.line_num = pa.line_num AND mc.prc_assignment_id = -99 AND nvl(mc.task_Id, -99) = nvl(pa.task_Id , -99) AND mc.set_of_books_id = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO'), 45,10) ), -99) AND pa.project_rev_rate_type = c1.conversion_type(+) AND pa.funding_rev_rate_type = c2.conversion_type(+)

View Text - HTML Formatted

SELECT MC.PROJECT_ID
, MC.TASK_ID
, MC.EVENT_NUM
, MC.LINE_NUM
, MC.AMOUNT
, MC.REQUEST_ID
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, MC.BATCH_NAME
, MC.DRAFT_REVENUE_NUM
, MC.DRAFT_REVENUE_ITEM_LINE_NUM
, MC.DRAFT_INVOICE_NUM
, MC.DRAFT_INVOICE_ITEM_LINE_NUM
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.CODE_COMBINATION_ID
, PA.LINE_NUM_REVERSED
, PA.REVERSED_FLAG
, PA.OUTPUT_VAT_TAX_ID
, PA.OUTPUT_TAX_CLASSIFICATION_CODE
, PA.OUTPUT_TAX_EXEMPT_FLAG
, PA.OUTPUT_TAX_EXEMPT_REASON_CODE
, PA.OUTPUT_TAX_EXEMPT_NUMBER
, PA.PRC_GENERATED_FLAG
, PA.ORG_ID
, MC.CURRENCY_CODE
, MC.AMOUNT
, MC.AMOUNT
, MC.EXCHANGE_RATE
, MC.CONVERSION_DATE
, MC.RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(MC.RATE_TYPE)
, MC.RATE_TYPE
, MC.CONVERSION_DATE
, MC.EXCHANGE_RATE
, PA.BILL_TRANS_CURRENCY_CODE
, PA.BILL_TRANS_AMOUNT
, PA.REVPROC_CURRENCY_CODE
, PA.REVPROC_RATE_TYPE
, PA.REVPROC_RATE_DATE
, PA.REVPROC_EXCHANGE_RATE
, PA.INVPROC_CURRENCY_CODE
, PA.INVPROC_RATE_TYPE
, PA.INVPROC_RATE_DATE
, PA.INVPROC_EXCHANGE_RATE
, PA.PROJECT_CURRENCY_CODE
, C1.USER_CONVERSION_TYPE PROJECT_REV_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(PA.PROJECT_REV_RATE_TYPE)
, PA.PROJECT_REV_RATE_DATE
, PA.PROJECT_REV_EXCHANGE_RATE
, PA.PROJECT_REVENUE_AMOUNT
, PA.PROJECT_INV_RATE_TYPE
, PA.PROJECT_INV_RATE_DATE
, PA.PROJECT_INV_EXCHANGE_RATE
, PA.PROJECT_BILL_AMOUNT
, PA.FUNDING_CURRENCY_CODE
, C2.USER_CONVERSION_TYPE FUNDING_REV_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(PA.FUNDING_REV_RATE_TYPE)
, PA.FUNDING_REV_RATE_DATE
, PA.FUNDING_REV_EXCHANGE_RATE
, PA.FUNDING_REVENUE_AMOUNT
, PA.FUNDING_INV_RATE_TYPE
, PA.FUNDING_INV_RATE_DATE
, PA.FUNDING_INV_EXCHANGE_RATE
, PA.FUNDING_BILL_AMOUNT
, PA.RETENTION_RULE_ID
, PA.RETN_DRAFT_INVOICE_NUM
, PA.RETN_DRAFT_INVOICE_LINE_NUM
, PA.RETAINED_AMOUNT
, PA.INV_GEN_REJECTION_CODE
FROM PA_CUST_EVENT_RDL_ALL PA
, PA_MC_CUST_EVENT_RDL_ALL MC
, PA_CONVERSION_TYPES_V C1
, PA_CONVERSION_TYPES_V C2
WHERE MC.PROJECT_ID = PA.PROJECT_ID
AND MC.EVENT_NUM = PA.EVENT_NUM
AND MC.LINE_NUM = PA.LINE_NUM
AND MC.PRC_ASSIGNMENT_ID = -99
AND NVL(MC.TASK_ID
, -99) = NVL(PA.TASK_ID
, -99)
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)
AND PA.PROJECT_REV_RATE_TYPE = C1.CONVERSION_TYPE(+)
AND PA.FUNDING_REV_RATE_TYPE = C2.CONVERSION_TYPE(+)