DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGI_INVOICE_DISTRIBUTIONS_V

Object Details
Object Name: IGI_INVOICE_DISTRIBUTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_INVOICE_DISTRIBUTIONS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


IGI_INVOICE_DISTRIBUTIONS_V is used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PREPAY_DISTRIBUTION_ID NUMBER (15)
Invoice distribution identifier for the distribution on the prepayment that originated the prepayment application represented by the current distribution
ACCOUNTING_EVENT_ID NUMBER (15)
Accounting event identifier. Refers to the accounting event that accounted for the distribution
ACCOUNTING_DATE DATE
Yes Accounting date
ACCRUAL_POSTED_FLAG VARCHAR2 (1)
Accrual accounting status of the distribution. Values may be: Y if distribution has been accounted and system is set up for accrual basis accounting, or N if either the distribution has not been accounted or accrual basis accounting is not used.
ASSETS_ADDITION_FLAG VARCHAR2 (1) Yes Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N)
ASSETS_TRACKING_FLAG VARCHAR2 (1) Yes Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N
CASH_POSTED_FLAG VARCHAR2 (1)
Cash basis accounting status of the distribution. Values may be: Y if distribution has been accounted and the system is set up for cash basis accounting, N if either the distribution has not been accounted or system is not set up for cash basis accounting, or P if distribution has been partially accounted in the cash set of books
DISTRIBUTION_LINE_NUMBER NUMBER (15) Yes Distribution number
DIST_CODE_COMBINATION_ID NUMBER (15) Yes Accounting Flexfield identifier for account associated with a distribution
INVOICE_ID NUMBER (15) Yes Invoice identifier
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE
PERIOD_NAME VARCHAR2 (15) Yes Accounting period name
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books identifier
ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
No longer used
AMOUNT NUMBER

Invoice distribution amount
BASE_AMOUNT NUMBER

Amount of invoice in functional currency, only used for foreign currency invoices
BASE_INVOICE_PRICE_VARIANCE NUMBER

No longer used
BATCH_ID NUMBER (15)
Invoice batch identifier
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
DESCRIPTION VARCHAR2 (240)
Description
EXCHANGE_RATE_VARIANCE NUMBER

No longer used
FINAL_MATCH_FLAG VARCHAR2 (1)
Final match indicator for distribution matched to a purchase order
INCOME_TAX_REGION VARCHAR2 (10)
Reporting region for distribution for 1099 supplier
INVOICE_PRICE_VARIANCE NUMBER

No longer used
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
MATCH_STATUS_FLAG VARCHAR2 (1)
Validation status
POSTED_FLAG VARCHAR2 (1)
Flag that indicates if invoice distribution line has been accounted
PO_DISTRIBUTION_ID NUMBER (15)
Purchase order distribution identifier for purchase order or receipt matched invoice distributions
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
QUANTITY_INVOICED NUMBER

Quantity billed for purchase order or receipt matched invoice distributions
RATE_VAR_CODE_COMBINATION_ID NUMBER (15)
No longer used
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REVERSAL_FLAG VARCHAR2 (1)
Flag that indicates if distribution is part of a reversal pair
TYPE_1099 VARCHAR2 (10)
1099 type
UNIT_PRICE NUMBER

Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections
VAT_CODE VARCHAR2 (15)
No longer used
AMOUNT_ENCUMBERED NUMBER

No longer used
BASE_AMOUNT_ENCUMBERED NUMBER

No longer used
ENCUMBERED_FLAG VARCHAR2 (1)
Flag indicating encumbrance status of distribution
EXCHANGE_DATE DATE

No longer used
EXCHANGE_RATE NUMBER

No longer used
EXCHANGE_RATE_TYPE VARCHAR2 (30)
No longer used
PRICE_ADJUSTMENT_FLAG VARCHAR2 (1)
No longer used
PRICE_VAR_CODE_COMBINATION_ID NUMBER (15)
No longer used
QUANTITY_UNENCUMBERED NUMBER

No longer used
STAT_AMOUNT NUMBER

Amount associated with a distribution for measuring statistical quantities
AMOUNT_TO_POST NUMBER

No longer used
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column.
BASE_AMOUNT_TO_POST NUMBER

No longer used
CASH_JE_BATCH_ID NUMBER (15)
No longer used
EXPENDITURE_ITEM_DATE DATE

Date for project expenditure item used to build Accounting Flexfield for project-related distribution
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Identifier for project organization used to build Accounting Flexfield for project-related distribution
EXPENDITURE_TYPE VARCHAR2 (30)
Project expenditure type used to build Accounting Flexfield for project-related distribution
JE_BATCH_ID NUMBER (15)
No longer used
PARENT_INVOICE_ID NUMBER (15)
Identifier for invoice matched to a credit or debit memo
PA_ADDITION_FLAG VARCHAR2 (1)
Flag that indicates if project related invoice distributions have been transferred into Oracle Projects
PA_QUANTITY NUMBER (22)
Project item quantity used to build Accounting Flexfield for project-related distribution
POSTED_AMOUNT NUMBER

No longer used
POSTED_BASE_AMOUNT NUMBER

No longer used
PREPAY_AMOUNT_REMAINING NUMBER

Amount of prepayment that can still be applied to an invoice
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
No longer used
PROJECT_ID NUMBER (15)
Identifier for project used to build Accounting Flexfield for project-related distribution
TASK_ID NUMBER (15)
Identifier for project task used to build Accounting Flexfield for project-related distribution
USSGL_TRANSACTION_CODE VARCHAR2 (30)
No longer used
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
No longer used
EARLIEST_SETTLEMENT_DATE DATE

No longer used
REQ_DISTRIBUTION_ID NUMBER (15)
No longer used
QUANTITY_VARIANCE NUMBER

No longer used
BASE_QUANTITY_VARIANCE NUMBER

No longer used
PACKET_ID NUMBER (15)
Budgetary control packet identifier for distributions that fail funds checking
AWT_FLAG VARCHAR2 (1)
Flag to determine if distribution is subject to withholding tax (Y, N, null)
AWT_GROUP_ID NUMBER (15)
Withholding tax group identifier
AWT_TAX_RATE_ID NUMBER (15)
Withholding tax rate identifier
AWT_GROSS_AMOUNT NUMBER

Amount subject to withholding tax
AWT_INVOICE_ID NUMBER (15)
Refers to the withholding tax invoice created from this distribution
AWT_ORIGIN_GROUP_ID NUMBER (15)
Foreign key to AP_AWT_GROUPS; refers to the parent withholding tax group; this column is only populated for automatically created withholding tax distributions
REFERENCE_1 VARCHAR2 (30)
Reference information from Oracle Projects expense reports or other external source invoice loading program
REFERENCE_2 VARCHAR2 (30)
Reference information from Oracle Projects expense reports or other external source invoice loading program
ORG_ID NUMBER (15)
Organization identifier
OTHER_INVOICE_ID NUMBER (15)
No longer used
AWT_INVOICE_PAYMENT_ID NUMBER (15)
Refers to the parent invoice payment. This column is populated only for automatically created withholding tax distributions at payment time
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
No longer used
TAX_CALCULATED_FLAG VARCHAR2 (1)
No longer used
LINE_GROUP_NUMBER NUMBER (15)
No longer used
RECEIPT_VERIFIED_FLAG VARCHAR2 (1)
Indicates whether receipts verified
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether receipts required
RECEIPT_MISSING_FLAG VARCHAR2 (1)
Indicates whether receipts missing
JUSTIFICATION VARCHAR2 (240)
Expense justification
EXPENSE_GROUP VARCHAR2 (80)
Expense group
START_EXPENSE_DATE DATE

Date when incurred expense started. Used for Expense Reports
END_EXPENSE_DATE DATE

Date when incurred expense ended. Used for Expense Reports
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
Currency code of receipt. Used for Expense Reports
RECEIPT_CONVERSION_RATE NUMBER

Exchange rate for currency of receipt. Used for Expense Reports
RECEIPT_CURRENCY_AMOUNT NUMBER

Amount in receipt currency. Used for Expense Reports
DAILY_AMOUNT NUMBER

Daily expense amount. Used for Expense Reports
WEB_PARAMETER_ID NUMBER

Self-Service Web Applications parameter identifier
ADJUSTMENT_REASON VARCHAR2 (240)
Reason for expense adjustment
AWARD_ID NUMBER (15)
If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information
MRC_DIST_CODE_COMBINATION_ID VARCHAR2 (2000)
No longer used
MRC_BASE_AMOUNT VARCHAR2 (2000)
No longer used
MRC_BASE_INV_PRICE_VARIANCE VARCHAR2 (2000)
No longer used
MRC_EXCHANGE_RATE_VARIANCE VARCHAR2 (2000)
No longer used
MRC_RATE_VAR_CCID VARCHAR2 (2000)
No longer used
MRC_EXCHANGE_DATE VARCHAR2 (2000)
No longer used
MRC_EXCHANGE_RATE VARCHAR2 (2000)
No longer used
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
No longer used
MRC_RECEIPT_CONVERSION_RATE VARCHAR2 (2000)
No longer used
DIST_MATCH_TYPE VARCHAR2 (25)
Flag that indicates type of distribution match. Validated against AP_LOOKUP_CODES with lookup type as MATCH_STATUS
RCV_TRANSACTION_ID NUMBER (15)
Receipt identifier for receipt matched invoice distributions
INVOICE_DISTRIBUTION_ID NUMBER (15) Yes Unique identifier for this table
PARENT_REVERSAL_ID NUMBER (15)
Invoice distribution identifier for distribution being reversed by the current distribution
TAX_RECOVERY_RATE NUMBER

No longer used
TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
No longer used
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
Indicates whether this tax line is recoverable or not. Used for tax lines
TAX_CODE_OVERRIDE_FLAG VARCHAR2 (1)
No Longer Used
TAX_CODE_ID NUMBER (15)
The tax code that was used on this distribution for the invoice date
PA_CC_AR_INVOICE_ID NUMBER (15)
No longer used
PA_CC_AR_INVOICE_LINE_NUM NUMBER (15)
No longer used
PA_CC_PROCESSED_CODE VARCHAR2 (1)
No longer used
MERCHANT_DOCUMENT_NUMBER VARCHAR2 (80)
Third party document number. Used for Expense Reports
MERCHANT_NAME VARCHAR2 (80)
Third party name. Used for Expense Reports
MERCHANT_REFERENCE VARCHAR2 (240)
Third party reference. Used for Expense Reports
MERCHANT_TAX_REG_NUMBER VARCHAR2 (80)
Third party tax registration number. Used for Expense Reports
MERCHANT_TAXPAYER_ID VARCHAR2 (80)
Third party tax identification number. Used for Expense Reports
COUNTRY_OF_SUPPLY VARCHAR2 (5)
Country where services or goods were originated. Used for Expense Reports
MATCHED_UOM_LOOKUP_CODE VARCHAR2 (25)
UOM used for the quantity invoiced during matching of this distributions
GMS_BURDENABLE_RAW_COST NUMBER (22)
Burdenable Raw Cost
CREDIT_CARD_TRX_ID NUMBER (15)
Credit card transaction identifier
UPGRADE_POSTED_AMT NUMBER

This column is only used during the upgrade t create accounting entries for Cash basis accounting
UPGRADE_BASE_POSTED_AMT NUMBER

This column is only used during the upgrade t create accounting entries for Cash basis accounting
INVENTORY_TRANSFER_STATUS VARCHAR2 (1)
Inventory transfer status indicates whether the invoice distribution has been processed by the transfer invoice variance program. A value of 'N' indicates that the distribution has not been transferred. A value of NULL indicates that either the distribution was transferred or is not eligible for transfer to inventory valuation. The default value of this column at the time of distribution creation is 'N'
IGI_MPP_ID NUMBER (15)
Not used.
IGI_MPP_LINE_NUM NUMBER (15)
Not used.
IGI_MPP_STATUS VARCHAR2 (1)
Not used.
IGI_MPP_ACCT_RULE NUMBER (15)
Not used.
IGI_MPP_FIRST_GL_DATE DATE

Not used.
IGI_MPP_DURATION NUMBER (15)
Not used.
IGI_MPP_EXP_CCID NUMBER (15)
Not used.
IGI_SAP_FLAG VARCHAR2 (1)
Indicates whether or not secondary hold has been approved.
IGI_ROWID ROWID (10)
Oracle Public Sector Financials (International) row ID
DIST_ROWID ROWID (10)
Distribution row
INVOICE_LINE_NUMBER NUMBER

Invoice line number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      IGI_MPP_ID
,      IGI_MPP_LINE_NUM
,      IGI_MPP_STATUS
,      IGI_MPP_ACCT_RULE
,      IGI_MPP_FIRST_GL_DATE
,      IGI_MPP_DURATION
,      IGI_MPP_EXP_CCID
,      IGI_SAP_FLAG
,      IGI_ROWID
,      DIST_ROWID
,      INVOICE_LINE_NUMBER
FROM APPS.IGI_INVOICE_DISTRIBUTIONS_V;

Dependencies

[top of page]

APPS.IGI_INVOICE_DISTRIBUTIONS_V references the following:

SchemaAPPS
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymIGI_INVOICE_DISTRIBUTIONS
APPS.IGI_INVOICE_DISTRIBUTIONS_V is referenced by following:

SchemaAPPS
ViewIGI_AP_INVOICE_V
ViewIGI_AP_INV_DISTRIBUTIONS_V
ViewIGI_SAP_EXCEPTIONS_V