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

VIEW: APPS.PA_TRANSFER_AP_INVOICES_VIEW

Object Details
Object Name: PA_TRANSFER_AP_INVOICES_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_TRANSFER_AP_INVOICES_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15)
Invoice identifier
INVOICE_DISTRIBUTION_ID NUMBER (15)
Invoice Distribution Identifier
INVOICE_LINE_NUMBER NUMBER

Invoice Line Number
CORRECTED_INVOICE_DIST_ID NUMBER (15)
Corrected Invoice Distribution Identifier
CHARGE_APPLICABLE_TO_DIST_ID NUMBER (15)
Charge Applicable To Distribution Identifier
RELATED_ID NUMBER (15)
Related Identifier
PARENT_REVERSAL_ID NUMBER (15)
Parent Reversal Identifier
CANCELLATION_FLAG VARCHAR2 (1)
Flag to indicate if the distribution was created as a result of the invoice being cancelled
AMOUNT_VARIANCE NUMBER

Amount variance in entered currency for invoice distributions matched to service shipment or receipt
BASE_AMOUNT_VARIANCE NUMBER

Amount variance in functional currency for invoice distributions matched to service shipment or receipt
DIST_CODE_COMBINATION_ID NUMBER

Accounting flexfield identifier for expense account associated with a distribution line
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
ACCOUNTING_DATE DATE

Accounting date
PERIOD_NAME VARCHAR2 (15)
Period name
SET_OF_BOOKS_ID NUMBER (15)
Set of books identifier
AMOUNT NUMBER

Invoice distribution amount
DESCRIPTION VARCHAR2 (240)
Description
TYPE_1099 VARCHAR2 (10)
1099 type
VAT_CODE VARCHAR2 (15)
Value-added tax code
POSTED_FLAG VARCHAR2 (1)
Flag that indicates if invoice distribution has been posted
BATCH_ID NUMBER (15)
Invoice batch identifier
REQ_DISTRIBUTION_ID NUMBER

No longer used
QUANTITY_INVOICED NUMBER

Quantity billed for purchase order matched invoice distributions
UNIT_PRICE NUMBER

Unit price for purchase order matched invoice items
PRICE_ADJUSTMENT_FLAG VARCHAR2 (1)
No longer used
MATCH_STATUS_FLAG VARCHAR2 (1)
Approval status
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield context field
ATTRIBUTE1 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
PREPAY_AMOUNT_REMAINING NUMBER

Amount of prepayment that can still be applied to an invoice
EARLIEST_SETTLEMENT_DATE DATE

Date associated with a prepayment after which you can apply invoices against prepayment (only used for temporary prepayments, column is null for permanent prepayments)
ASSETS_ADDITION_FLAG VARCHAR2 (1)
Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N)
ASSETS_TRACKING_FLAG VARCHAR2 (1)
Flag that indicates if distribution line is tracked in Oracle Assets (Y or N)
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Distribution line number
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Name of line type (ITEM, TAX, FREIGHT, MISCELLANEOUS)
PO_DISTRIBUTION_ID NUMBER

Purchase order distribution line identifier for purchase order matched invoice distributions
BASE_AMOUNT NUMBER

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

Exchange rate for a foreign currency invoice
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for a foreign currency invoice
EXCHANGE_DATE DATE

Date exchange rate is obtained from daily rates table
PA_ADDITION_FLAG VARCHAR2 (1)
Flag that indicates if project-related invoice distributions have been transferred to Oracle Projects (Y or N)
JE_BATCH_ID NUMBER

Journal entry batch identifier
POSTED_AMOUNT NUMBER

Amount posted to general ledger in invoice currency (used only if cash or combined basis accounting is used)
POSTED_BASE_AMOUNT NUMBER

Amount posted to general ledger in functional currency (used only if cash or combined basis accounting is used)
ENCUMBERED_FLAG VARCHAR2 (1)
Flag indicating encumbrance status of distribution line
AMOUNT_ENCUMBERED NUMBER

Variance between an invoice and its matched purchase order in foreign currency (excluding exchange rate variances for matched distribution lines)
QUANTITY_UNENCUMBERED NUMBER

No longer used
AMOUNT_TO_POST NUMBER

Amount to post when using Cash Basis accounting
BASE_AMOUNT_TO_POST NUMBER

Base amount to post when using Cash Basis accounting
ACCRUAL_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if distribution has been posted to accrual set of books (Y or N)
CASH_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if distribution has been posted to cash set of books (Y or N)
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
CASH_JE_BATCH_ID NUMBER

Cash journal entry batch identifier
REQUEST_ID NUMBER (15)
Standard Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who Column
PROGRAM_ID NUMBER (15)
Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
STAT_AMOUNT NUMBER

Amount associated with a distribution line for measuring statistical quantities
BASE_AMOUNT_ENCUMBERED NUMBER

Variance between an invoice and its matched purchase order in functional currency (including exchange rate variances for matched distribution lines)
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 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
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ACCTS_PAY_CODE_COMBINATION_ID NUMBER

Accounting Flexfield identifier for liability account associated with a distribution line
RATE_VAR_CODE_COMBINATION_ID NUMBER

Accounting Flexfield identifier for exchange rate variance account for distribution line
PRICE_VAR_CODE_COMBINATION_ID NUMBER

Accounting Flexfield identifier for price variance account associated with a distribution line matched to a purchase order
EXCHANGE_RATE_VARIANCE NUMBER

Amount of exchange rate variance for invoice distribution line matched to a purchase order
INVOICE_PRICE_VARIANCE NUMBER

Amount of price variance in invoice currency for invoice distribution line matched to purchase order
BASE_INVOICE_PRICE_VARIANCE NUMBER

Amount of price variance in functional currency (distributed to expense Accounting Flexfield) for invoice distribution line matched to purchase order
REVERSAL_FLAG VARCHAR2 (1)
Flag that indicates if distribution line is reversing distribution line
PARENT_INVOICE_ID NUMBER (15)
Identifier for invoice matched to a credit or debit memo
INCOME_TAX_REGION VARCHAR2 (10)
Reporting region for distribution line for 1099 vendor
FINAL_MATCH_FLAG VARCHAR2 (1)
Final match indicator for distribution line matched to purchase order
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
USSGL Transaction Code Descriptive Flexfield context column
EXPENDITURE_ITEM_DATE DATE

Date for project expenditure item used to build Accounting Flexfield for project-related distribution line
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Identifier for project organization used to build Accounting Flexfield for project-related distribution line
EXPENDITURE_TYPE VARCHAR2 (30)
Project expenditure type used to build Accounting Flexfield for project-related distribution line
PA_QUANTITY NUMBER

Project item quantity used to build Accounting Flexfield for project-related distribution line
PROJECT_ID NUMBER (15)
Identifier for project used to build Accounting Flexfield for project-related distribution line
TASK_ID NUMBER (15)
Identifier for project task used to build Accounting Flexfield for project-related distribution line
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
Oracle Projects Descriptive Flexfield context column
DESTINATION_TYPE_CODE VARCHAR2 (25)
Oracle Purchasing destination type code
RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_CONVERSION_RATE NUMBER

TAX_RECOVERABLE_FLAG VARCHAR2 (1)
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
JUSTIFICATION VARCHAR2 (240)
PREPAY_DISTRIBUTION_ID NUMBER (15)
HISTORICAL_FLAG VARCHAR2 (1)
SELF_ASSESSED_FLAG VARCHAR2 (1)
Query Text

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


SELECT INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
,      CORRECTED_INVOICE_DIST_ID
,      CHARGE_APPLICABLE_TO_DIST_ID
,      RELATED_ID
,      PARENT_REVERSAL_ID
,      CANCELLATION_FLAG
,      AMOUNT_VARIANCE
,      BASE_AMOUNT_VARIANCE
,      DIST_CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      SET_OF_BOOKS_ID
,      AMOUNT
,      DESCRIPTION
,      TYPE_1099
,      VAT_CODE
,      POSTED_FLAG
,      BATCH_ID
,      REQ_DISTRIBUTION_ID
,      QUANTITY_INVOICED
,      UNIT_PRICE
,      PRICE_ADJUSTMENT_FLAG
,      MATCH_STATUS_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      PREPAY_AMOUNT_REMAINING
,      EARLIEST_SETTLEMENT_DATE
,      ASSETS_ADDITION_FLAG
,      ASSETS_TRACKING_FLAG
,      DISTRIBUTION_LINE_NUMBER
,      LINE_TYPE_LOOKUP_CODE
,      PO_DISTRIBUTION_ID
,      BASE_AMOUNT
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      PA_ADDITION_FLAG
,      JE_BATCH_ID
,      POSTED_AMOUNT
,      POSTED_BASE_AMOUNT
,      ENCUMBERED_FLAG
,      AMOUNT_ENCUMBERED
,      QUANTITY_UNENCUMBERED
,      AMOUNT_TO_POST
,      BASE_AMOUNT_TO_POST
,      ACCRUAL_POSTED_FLAG
,      CASH_POSTED_FLAG
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CASH_JE_BATCH_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STAT_AMOUNT
,      BASE_AMOUNT_ENCUMBERED
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE15
,      ACCTS_PAY_CODE_COMBINATION_ID
,      RATE_VAR_CODE_COMBINATION_ID
,      PRICE_VAR_CODE_COMBINATION_ID
,      EXCHANGE_RATE_VARIANCE
,      INVOICE_PRICE_VARIANCE
,      BASE_INVOICE_PRICE_VARIANCE
,      REVERSAL_FLAG
,      PARENT_INVOICE_ID
,      INCOME_TAX_REGION
,      FINAL_MATCH_FLAG
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      PA_QUANTITY
,      PROJECT_ID
,      TASK_ID
,      PROJECT_ACCOUNTING_CONTEXT
,      DESTINATION_TYPE_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      TAX_RECOVERABLE_FLAG
,      ACCRUE_ON_RECEIPT_FLAG
,      JUSTIFICATION
,      PREPAY_DISTRIBUTION_ID
,      HISTORICAL_FLAG
,      SELF_ASSESSED_FLAG
FROM APPS.PA_TRANSFER_AP_INVOICES_VIEW;

Dependencies

[top of page]

APPS.PA_TRANSFER_AP_INVOICES_VIEW references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS
SynonymAP_SELF_ASSESSED_TAX_DIST
SynonymAP_SYSTEM_PARAMETERS
PL/SQL PackageAP_UTILITIES_PKG - show dependent code
SynonymMTL_SYSTEM_ITEMS
PL/SQL PackagePA_NL_INSTALLED - show dependent code
SynonymPO_DISTRIBUTIONS
SynonymPO_LINES_ALL
APPS.PA_TRANSFER_AP_INVOICES_VIEW is referenced by following:

SchemaAPPS
PL/SQL PackagePAAPIMP_PKG - show dependent code