Product: | AP - Payables |
---|---|
Description: | MULTI-ORG MRC view |
Implementation/DBA Data: | Not implemented in this database |
SELECT B.PREPAY_DISTRIBUTION_ID
, B.ACCOUNTING_EVENT_ID
, B.ACCOUNTING_DATE
, B.ACCRUAL_POSTED_FLAG
, B.ASSETS_ADDITION_FLAG
, B.ASSETS_TRACKING_FLAG
, B.CASH_POSTED_FLAG
, MC.DISTRIBUTION_LINE_NUMBER
, MC.DIST_CODE_COMBINATION_ID
, MC.INVOICE_ID
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, MC.LINE_TYPE_LOOKUP_CODE
, B.PERIOD_NAME
, MC.SET_OF_BOOKS_ID
, B.ACCTS_PAY_CODE_COMBINATION_ID
, MC.AMOUNT
, MC.BASE_AMOUNT
, MC.BASE_INVOICE_PRICE_VARIANCE
, B.BATCH_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.DESCRIPTION
, MC.EXCHANGE_RATE_VARIANCE
, B.FINAL_MATCH_FLAG
, B.INCOME_TAX_REGION
, B.INVOICE_PRICE_VARIANCE
, B.LAST_UPDATE_LOGIN
, B.MATCH_STATUS_FLAG
, B.POSTED_FLAG
, B.PO_DISTRIBUTION_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, B.QUANTITY_INVOICED
, MC.RATE_VAR_CODE_COMBINATION_ID
, B.REQUEST_ID
, B.REVERSAL_FLAG
, B.TYPE_1099
, B.UNIT_PRICE
, B.VAT_CODE
, B.AMOUNT_ENCUMBERED
, B.BASE_AMOUNT_ENCUMBERED
, B.ENCUMBERED_FLAG
, MC.EXCHANGE_DATE
, MC.EXCHANGE_RATE
, MC.EXCHANGE_RATE_TYPE
, B.PRICE_ADJUSTMENT_FLAG
, B.PRICE_VAR_CODE_COMBINATION_ID
, B.QUANTITY_UNENCUMBERED
, B.STAT_AMOUNT
, MC.AMOUNT_TO_POST
, B.ATTRIBUTE1
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE_CATEGORY
, MC.BASE_AMOUNT_TO_POST
, B.CASH_JE_BATCH_ID
, B.EXPENDITURE_ITEM_DATE
, B.EXPENDITURE_ORGANIZATION_ID
, B.EXPENDITURE_TYPE
, B.JE_BATCH_ID
, B.PARENT_INVOICE_ID
, B.PA_ADDITION_FLAG
, B.PA_QUANTITY
, MC.POSTED_AMOUNT
, MC.POSTED_BASE_AMOUNT
, B.PREPAY_AMOUNT_REMAINING
, B.PROJECT_ACCOUNTING_CONTEXT
, B.PROJECT_ID
, B.TASK_ID
, B.USSGL_TRANSACTION_CODE
, B.USSGL_TRX_CODE_CONTEXT
, B.EARLIEST_SETTLEMENT_DATE
, B.REQ_DISTRIBUTION_ID
, B.QUANTITY_VARIANCE
, B.BASE_QUANTITY_VARIANCE
, B.PACKET_ID
, B.AWT_FLAG
, B.AWT_GROUP_ID
, B.AWT_TAX_RATE_ID
, B.AWT_GROSS_AMOUNT
, B.AWT_INVOICE_ID
, B.AWT_ORIGIN_GROUP_ID
, B.REFERENCE_1
, B.REFERENCE_2
, B.ORG_ID
, B.OTHER_INVOICE_ID
, B.AWT_INVOICE_PAYMENT_ID
, B.GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10
, B.GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20
, B.AMOUNT_INCLUDES_TAX_FLAG
, B.TAX_CALCULATED_FLAG
, B.LINE_GROUP_NUMBER
, B.RECEIPT_VERIFIED_FLAG
, B.RECEIPT_REQUIRED_FLAG
, B.RECEIPT_MISSING_FLAG
, B.JUSTIFICATION
, B.EXPENSE_GROUP
, B.START_EXPENSE_DATE
, B.END_EXPENSE_DATE
, B.RECEIPT_CURRENCY_CODE
, B.RECEIPT_CONVERSION_RATE
, B.RECEIPT_CURRENCY_AMOUNT
, B.DAILY_AMOUNT
, B.WEB_PARAMETER_ID
, B.ADJUSTMENT_REASON
, B.AWARD_ID
, B.MRC_DIST_CODE_COMBINATION_ID
, B.MRC_BASE_AMOUNT
, B.MRC_BASE_INV_PRICE_VARIANCE
, B.MRC_EXCHANGE_RATE_VARIANCE
, B.MRC_RATE_VAR_CCID
, B.MRC_EXCHANGE_DATE
, B.MRC_EXCHANGE_RATE
, B.MRC_EXCHANGE_RATE_TYPE
, B.MRC_RECEIPT_CONVERSION_RATE
, B.DIST_MATCH_TYPE
, B.RCV_TRANSACTION_ID
, MC.INVOICE_DISTRIBUTION_ID
, B.PARENT_REVERSAL_ID
, B.TAX_RECOVERY_RATE
, B.TAX_RECOVERY_OVERRIDE_FLAG
, B.TAX_RECOVERABLE_FLAG
, B.TAX_CODE_OVERRIDE_FLAG
, B.TAX_CODE_ID
, B.PA_CC_AR_INVOICE_ID
, B.PA_CC_AR_INVOICE_LINE_NUM
, B.PA_CC_PROCESSED_CODE
, B.MERCHANT_DOCUMENT_NUMBER
, B.MERCHANT_NAME
, B.MERCHANT_REFERENCE
, B.MERCHANT_TAX_REG_NUMBER
, B.MERCHANT_TAXPAYER_ID
, B.COUNTRY_OF_SUPPLY
, B.MATCHED_UOM_LOOKUP_CODE
, B.GMS_BURDENABLE_RAW_COST
, B.CREDIT_CARD_TRX_ID
, MC.UPGRADE_POSTED_AMT
, MC.UPGRADE_BASE_POSTED_AMT
, B.INVENTORY_TRANSFER_STATUS
, B.COMPANY_PREPAID_INVOICE_ID
, B.CC_REVERSAL_FLAG
, B.PREPAY_TAX_PARENT_ID
, B.AWT_WITHHELD_AMT
, B.INVOICE_INCLUDES_PREPAY_FLAG
, B.PRICE_CORRECT_INV_ID
, B.PRICE_CORRECT_QTY
, B.PA_CMT_XFACE_FLAG
, B.CANCELLATION_FLAG
, B.FULLY_PAID_ACCTD_FLAG
, B.AMOUNT_VARIANCE
, B.BASE_AMOUNT_VARIANCE
, B. RECURRING_PAYMENT_ID
, B.ROOT_DISTRIBUTION_ID
, B.XINV_PARENT_REVERSAL_ID
FROM AP_INVOICE_DISTRIBUTIONS_ALL B
, AP_MC_INVOICE_DISTS MC
WHERE B.INVOICE_DISTRIBUTION_ID = MC.INVOICE_DISTRIBUTION_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)