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_DRAFT_INVOICE_LINES_ALL_V

Object Details

Object Name:	PA_DRAFT_INVOICE_LINES_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_DRAFT_INVOICE_LINES_ALL_V
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	Comments
ROW_ID	ROWID	(10)
PROJECT_ID	NUMBER	(15)
DRAFT_INVOICE_NUM	NUMBER	(15)
LINE_NUM	NUMBER	(15)
TEXT	VARCHAR2	(240)
TAXABLE_FLAG	VARCHAR2	(1)
AMOUNT	NUMBER	(22)
INV_AMOUNT	NUMBER		The amount to be billed in the invoicing currency code for the draft invoice item
UNEARNED_REVENUE_CR	NUMBER	(22)
UNBILLED_RECEIVABLE_DR	NUMBER	(22)
TASK_ID	NUMBER	(15)
EVENT_TASK_ID	NUMBER	(15)
EVENT_NUM	NUMBER	(15)
EVENT_ID	NUMBER
SHIP_TO_ADDRESS_ID	NUMBER	(15)
INVOICE_LINE_TYPE	VARCHAR2	(30)
DRAFT_INV_LINE_NUM_CREDITED	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who Column
CREATION_DATE	DATE		Standard Who Column
CREATED_BY	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
REQUEST_ID	NUMBER	(15)	Standard Who Column
EVENT_TASK_NUMBER	VARCHAR2	(25)
TASK_NAME	VARCHAR2	(20)	Task Name
COMPLETION_DATE	DATE
WORK_SITE	VARCHAR2	(183)
TASK_NUMBER	VARCHAR2	(25)
OUTPUT_VAT_TAX_ID	NUMBER		Default output tax code identifier for invoice line
OUTPUT_TAX_CLASSIFICATION_CODE	VARCHAR2	(50)	Default output tax code for invoice line
OUTPUT_TAX_EXEMPT_FLAG	VARCHAR2	(1)	Default Tax Handling for invoice line either have S, R or E
OUTPUT_TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)	Default Tax Exempt Reason Code for lines that have tax exemplt flag set to E
OUTPUT_TAX_EXEMPT_NUMBER	VARCHAR2	(80)	Default Tax Exemption Certificate Number that have tax exempt flag set to E
OUTPUT_TAX_CODE	VARCHAR2	(50)
TAX_HANDLING	VARCHAR2	(80)
OUTPUT_TAX_EXEMPT_REASON	VARCHAR2	(80)
ACCT_AMOUNT	NUMBER		The Functional Currency amount of that has been accounted in Oracle Receivables.This column is populated in the Transfer Invoice Program from Release 11.5.
ROUNDING_AMOUNT	NUMBER		The Functional Rounding amount. This column is populated in the Transfer Invoice Program from Release 11.5.
UNBILLED_ROUNDING_AMOUNT_DR	NUMBER		The Functional Currency Unbilled Receivable Rounding amount. This column is populated in the Transfer Invoice Program from Release 11.5.
UNEARNED_ROUNDING_AMOUNT_CR	NUMBER		The Functional Currency Unearned Revenue Rounding amount. This column is populated in the Transfer Invoice Program from Release 11.5.
TRANSLATED_TEXT	VARCHAR2	(240)
CC_PROJECT_ID	NUMBER
CC_TAX_TASK_ID	NUMBER
CC_REV_CODE_COMBINATION_ID	NUMBER
BILL_TRANS_CURRENCY_CODE	VARCHAR2	(15)	Bill Transaction Currency for Events.
INVPROC_CURRENCY_CODE	VARCHAR2	(15)	Invoice Processing Currency Code.
INVPROC_RATE_TYPE	VARCHAR2	(30)	Exchange rate type used to determine the conversion rate from Event Transaction Currency to Invoice Processing Currency.
INVPROC_RATE_DATE	DATE		Rate date used to determine the conversion rate from Event Transaction Currency to Invoice Processing Currency.
INVPROC_EXCHANGE_RATE	NUMBER		Conversion rate used to convert from Event Transaction Currency to Invoice Processing Currency.
INVPROC_BILL_AMOUNT	NUMBER	(22)	Amount in Invoice Processing Currency.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)	Project Functional Currency Code.
PROJFUNC_RATE_TYPE	VARCHAR2	(30)	Exchange rate type used to determine the conversion rate from Event Transaction Currency to Project Functional Currency.
PROJFUNC_RATE_DATE	DATE		Rate date used to determine the conversion rate from Event Transaction Currency to Project Functional Currency.
PROJFUNC_EXCHANGE_RATE	NUMBER		Conversion rate used to convert from Event Transaction Currency to Project Functional Currency.
PROJFUNC_BILL_AMOUNT	NUMBER		Amount in Project Functional Currency.
PROJ_CURRENCY_CODE	VARCHAR2	(15)	Project Currency Code.
PROJ_RATE_TYPE	VARCHAR2	(30)	Exchange rate type used to determine the conversion rate from Event Transaction Currency to Project Currency.
PROJ_RATE_DATE	DATE		Rate date used to determine the conversion rate from Event Transaction Currency to Project Currency.
PROJ_EXCHANGE_RATE	NUMBER		Conversion rate used to convert from Event Transaction Currency to Project Currency.
PROJ_BILL_AMOUNT	NUMBER		Amount in Project Currency.
FUNDING_CURRENCY_CODE	VARCHAR2	(15)	Funding Currency Code.
FUNDING_RATE_TYPE	VARCHAR2	(30)	Exchange rate type used to determine the conversion rate from Event Transaction Currency to Funding Currency.
FUNDING_RATE_DATE	DATE		Rate date used to determine the conversion rate from Event Transaction Currency to Funding Currency.
FUNDING_EXCHANGE_RATE	NUMBER		Conversion rate used to convert from Event Transaction Currency to Funding Currency.
FUNDING_BILL_AMOUNT	NUMBER		Amount in Funding Currency.
CREDIT_AMOUNT	NUMBER		The amount to be credited againts this line
CREDIT_PROCESS_FLAG	VARCHAR2	(1)	Column indicating the line is to be processed for credit procesing
INV_CURRENCY_CODE	VARCHAR2	(15)	Invoice curreny

Query Text

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


SELECT ROW_ID
,      PROJECT_ID
,      DRAFT_INVOICE_NUM
,      LINE_NUM
,      TEXT
,      TAXABLE_FLAG
,      AMOUNT
,      INV_AMOUNT
,      UNEARNED_REVENUE_CR
,      UNBILLED_RECEIVABLE_DR
,      TASK_ID
,      EVENT_TASK_ID
,      EVENT_NUM
,      EVENT_ID
,      SHIP_TO_ADDRESS_ID
,      INVOICE_LINE_TYPE
,      DRAFT_INV_LINE_NUM_CREDITED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      EVENT_TASK_NUMBER
,      TASK_NAME
,      COMPLETION_DATE
,      WORK_SITE
,      TASK_NUMBER
,      OUTPUT_VAT_TAX_ID
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_EXEMPT_FLAG
,      OUTPUT_TAX_EXEMPT_REASON_CODE
,      OUTPUT_TAX_EXEMPT_NUMBER
,      OUTPUT_TAX_CODE
,      TAX_HANDLING
,      OUTPUT_TAX_EXEMPT_REASON
,      ACCT_AMOUNT
,      ROUNDING_AMOUNT
,      UNBILLED_ROUNDING_AMOUNT_DR
,      UNEARNED_ROUNDING_AMOUNT_CR
,      TRANSLATED_TEXT
,      CC_PROJECT_ID
,      CC_TAX_TASK_ID
,      CC_REV_CODE_COMBINATION_ID
,      BILL_TRANS_CURRENCY_CODE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      INVPROC_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      PROJ_CURRENCY_CODE
,      PROJ_RATE_TYPE
,      PROJ_RATE_DATE
,      PROJ_EXCHANGE_RATE
,      PROJ_BILL_AMOUNT
,      FUNDING_CURRENCY_CODE
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      FUNDING_BILL_AMOUNT
,      CREDIT_AMOUNT
,      CREDIT_PROCESS_FLAG
,      INV_CURRENCY_CODE
FROM APPS.PA_DRAFT_INVOICE_LINES_ALL_V;

Dependencies

[top of page]

APPS.PA_DRAFT_INVOICE_LINES_ALL_V references the following:

APPS: AR_LOOKUPS; AR_VAT_TAX_ALL; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTY_SITES; PA_CONVERSION_TYPES_V; PA_DRAFT_INVOICES_ALL; PA_DRAFT_INVOICE_ITEMS; PA_EVENTS; PA_PROJECTS_ALL; PA_TASKS

APPS.PA_DRAFT_INVOICE_LINES_ALL_V is not referenced by any database object