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_V

Object Details

Object Name:	PA_DRAFT_INVOICE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_DRAFT_INVOICE_LINES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
PROJECT_ID	NUMBER	(15)	Yes
DRAFT_INVOICE_NUM	NUMBER	(15)	Yes
LINE_NUM	NUMBER	(15)	Yes
TEXT	VARCHAR2	(240)	Yes
TAXABLE_FLAG	VARCHAR2	(1)
AMOUNT	NUMBER	(22)	Yes
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)	Yes
DRAFT_INV_LINE_NUM_CREDITED	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	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)
COMPLETION_DATE	DATE
WORK_SITE	VARCHAR2	(183)
TASK_NUMBER	VARCHAR2	(25)
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_CLASSIFICATION_CODE	VARCHAR2	(50)		Default output tax code identifier for invoice line
OUTPUT_TAX_NAME	VARCHAR2	(80)		Default output tax name identifier for invoice line
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)	Yes	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.
UNEARNED_REVENUE_CR_MRC	NUMBER			Data associated with Multi Reporting Currecncy Schema Elimination
UNBILLED_RECEIVABLE_DR_MRC	NUMBER			Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_CURRENCY_CODE_MRC	VARCHAR2	(0)		Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_BILL_AMOUNT_MRC	VARCHAR2	(0)		Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_RATE_TYPE_MRC	VARCHAR2	(0)		Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_EXCHANGE_RATE_MRC	VARCHAR2	(0)		Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_CONVERSION_DATE_MRC	VARCHAR2	(0)		Data associated with Multi Reporting Currecncy Schema Elimination
CREDIT_AMOUNT	NUMBER
CREDIT_PROCESS_FLAG	VARCHAR2	(1)

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
,      COMPLETION_DATE
,      WORK_SITE
,      TASK_NUMBER
,      OUTPUT_TAX_EXEMPT_FLAG
,      OUTPUT_TAX_EXEMPT_REASON_CODE
,      OUTPUT_TAX_EXEMPT_NUMBER
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_NAME
,      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
,      UNEARNED_REVENUE_CR_MRC
,      UNBILLED_RECEIVABLE_DR_MRC
,      PROJFUNC_CURRENCY_CODE_MRC
,      PROJFUNC_BILL_AMOUNT_MRC
,      PROJFUNC_RATE_TYPE_MRC
,      PROJFUNC_EXCHANGE_RATE_MRC
,      PROJFUNC_CONVERSION_DATE_MRC
,      CREDIT_AMOUNT
,      CREDIT_PROCESS_FLAG
FROM APPS.PA_DRAFT_INVOICE_LINES_V;

Dependencies

[top of page]

APPS.PA_DRAFT_INVOICE_LINES_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; 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; ZX_OUTPUT_CLASSIFICATIONS_V

APPS.PA_DRAFT_INVOICE_LINES_V is not referenced by any database object