eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_NL_TRANSFER_AP_INV_VIEW

Object Details

Object Name:	PA_NL_TRANSFER_AP_INV_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_NL_TRANSFER_AP_INV_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)	Yes	Invoice identifier
DIST_CODE_COMBINATION_ID	NUMBER			Accounting flexfield identifier for expense account associated with a distribution line
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
ACCOUNTING_DATE	DATE		Yes	Accounting date
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	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	(15)		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)	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 line is tracked in Oracle Assets (Y or N)
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes	Distribution line number
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	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	(15)		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	(15)		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	(15)		Accounting Flexfield identifier for liability account associated with a distribution line
RATE_VAR_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for exchange rate variance account for distribution line
PRICE_VAR_CODE_COMBINATION_ID	NUMBER	(15)		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	(22)		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)
ORG_ID	NUMBER

Query Text

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


SELECT INVOICE_ID
,      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
,      ORG_ID
FROM APPS.PA_NL_TRANSFER_AP_INV_VIEW;

Dependencies

[top of page]

APPS.PA_NL_TRANSFER_AP_INV_VIEW references the following:

APPS: AP_INVOICE_DISTRIBUTIONS_ALL; MTL_SYSTEM_ITEMS; PO_DISTRIBUTIONS; PO_LINES_ALL

APPS.PA_NL_TRANSFER_AP_INV_VIEW is not referenced by any database object