FND Design Data [Home] [Help]

View: AP_INVOICE_DISTS_ALL_MRC_V

Product: AP - Payables
Description: MULTI-ORG MRC view
Implementation/DBA Data: Not implemented in this database
View Text

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)

Columns

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