View: PA_CUST_RDL_ALL_MRC_V2

Product:	PA - Projects
Description:	Multi-org, single currency view
Implementation/DBA Data:	APPS.PA_CUST_RDL_ALL_MRC_V2

View Text

SELECT MC.EXPENDITURE_ITEM_ID
, MC.LINE_NUM
, MC.AMOUNT
, MC.BILL_AMOUNT
, MC.REQUEST_ID
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, MC.BATCH_NAME
, MC.RAW_COST
, MC.PROJECT_ID
, 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.FUNCTION_CODE
, PA.FUNCTION_TRANSACTION_CODE
, PA.ADDITIONAL_REVENUE_FLAG
, PA.INVOICE_ELIGIBLE_FLAG
, PA.REVERSED_FLAG
, PA.LINE_NUM_REVERSED
, PA.REV_IND_COMPILED_SET_ID
, PA.INV_IND_COMPILED_SET_ID
, 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.BILL_AMOUNT
, MC.EXCHANGE_RATE
, MC.CONVERSION_DATE
, MC.RATE_TYPE
, PA.BILL_TRANS_CURRENCY_CODE
, PA.BILL_TRANS_AMOUNT
, PA.BILL_TRANS_BILL_AMOUNT
, PA.BILL_RATE
, 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
, 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
, MC.PROJFUNC_INV_RATE_TYPE
, MC.PROJFUNC_INV_RATE_DATE
, MC.PROJFUNC_INV_EXCHANGE_RATE
, PA.FUNDING_CURRENCY_CODE
, 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.LABOR_MULTIPLIER
, PA.DISCOUNT_PERCENTAGE
, PA.AMOUNT_CALCULATION_CODE
, PA.BILL_MARKUP_PERCENTAGE
, PA.RATE_SOURCE_ID
, PA.INV_GEN_REJECTION_CODE
, PA.RETENTION_RULE_ID
, PA.RETN_DRAFT_INVOICE_NUM
, PA.RETN_DRAFT_INVOICE_LINE_NUM
, PA.RETAINED_AMOUNT
, PA.RATE_DISC_REASON_CODE
FROM PA_CUST_REV_DIST_LINES_ALL PA
, PA_MC_CUST_RDL_ALL MC
WHERE MC.EXPENDITURE_ITEM_ID = PA.EXPENDITURE_ITEM_ID
AND MC.LINE_NUM = PA.LINE_NUM
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99) UNION ALL SELECT PA.EXPENDITURE_ITEM_ID
, PA.LINE_NUM
, PA.AMOUNT
, PA.BILL_AMOUNT
, PA.REQUEST_ID
, PA.PROGRAM_APPLICATION_ID
, PA.PROGRAM_ID
, PA.PROGRAM_UPDATE_DATE
, PA.BATCH_NAME
, PA.RAW_COST
, PA.PROJECT_ID
, PA.DRAFT_REVENUE_NUM
, PA.DRAFT_REVENUE_ITEM_LINE_NUM
, PA.DRAFT_INVOICE_NUM
, PA.DRAFT_INVOICE_ITEM_LINE_NUM
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.CODE_COMBINATION_ID
, PA.FUNCTION_CODE
, PA.FUNCTION_TRANSACTION_CODE
, PA.ADDITIONAL_REVENUE_FLAG
, PA.INVOICE_ELIGIBLE_FLAG
, PA.REVERSED_FLAG
, PA.LINE_NUM_REVERSED
, PA.REV_IND_COMPILED_SET_ID
, PA.INV_IND_COMPILED_SET_ID
, 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
, PA.PROJFUNC_CURRENCY_CODE
, PA.PROJFUNC_REVENUE_AMOUNT
, PA.PROJFUNC_BILL_AMOUNT
, PA.PROJFUNC_REV_EXCHANGE_RATE
, PA.PROJFUNC_REV_RATE_DATE
, PA.PROJFUNC_REV_RATE_TYPE
, PA.BILL_TRANS_CURRENCY_CODE
, PA.BILL_TRANS_AMOUNT
, PA.BILL_TRANS_BILL_AMOUNT
, PA.BILL_RATE
, 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
, 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.PROJFUNC_INV_RATE_TYPE
, PA.PROJFUNC_INV_RATE_DATE
, PA.PROJFUNC_INV_EXCHANGE_RATE
, PA.FUNDING_CURRENCY_CODE
, 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.LABOR_MULTIPLIER
, PA.DISCOUNT_PERCENTAGE
, PA.AMOUNT_CALCULATION_CODE
, PA.BILL_MARKUP_PERCENTAGE
, PA.RATE_SOURCE_ID
, PA.INV_GEN_REJECTION_CODE
, PA.RETENTION_RULE_ID
, PA.RETN_DRAFT_INVOICE_NUM
, PA.RETN_DRAFT_INVOICE_LINE_NUM
, PA.RETAINED_AMOUNT
, PA.RATE_DISC_REASON_CODE
FROM PA_CUST_REV_DIST_LINES_ALL PA
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_IMPLEMENTATIONS_ALL IMP1
, PA_IMPLEMENTATIONS_ALL IMP2
WHERE EI.RECVR_ORG_ID <> EI.ORG_ID
AND EI.EXPENDITURE_ITEM_ID = PA.EXPENDITURE_ITEM_ID
AND PA.ORG_ID <> MO_GLOBAL.GET_CURRENT_ORG_ID --SHARED SERVICES CHANGE
AND EI.ORG_ID = IMP1.ORG_ID
AND EI.RECVR_ORG_ID = IMP2.ORG_ID
AND IMP1.SET_OF_BOOKS_ID <> IMP2.SET_OF_BOOKS_ID

Columns