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	(4000)		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)
INV_RATE_TYPE	VARCHAR2	(30)		Invoice currency exchange rate type for the draft invoice item
INV_RATE_DATE	DATE			Invoice currency exchange rate date for the draft invoice item
INV_EXCHANGE_RATE	NUMBER			Invoice currency exchange rate for the draft invoice item
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE1	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE2	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE3	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE4	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE5	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE6	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE7	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE8	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE9	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE10	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE11	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE12	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE13	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE14	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE15	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE16	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE17	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE18	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE19	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE20	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE21	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE22	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE23	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE24	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE25	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE26	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE27	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE28	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE29	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
GLOBAL_ATTRIBUTE30	VARCHAR2	(240)		- Global Descriptive Flexfield for storing Federal Financial codes.
PROVIDER_ORGANIZATION_NAME	VARCHAR2	(240)		- Provider Organization name
RECEIVER_ORGANIZATION_NAME	VARCHAR2	(240)		- Revceiver Organization name.

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
,      INV_RATE_TYPE
,      INV_RATE_DATE
,      INV_EXCHANGE_RATE
,      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
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      PROVIDER_ORGANIZATION_NAME
,      RECEIVER_ORGANIZATION_NAME
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; HR_ALL_ORGANIZATION_UNITS; 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_OUTPUT_TAX - show dependent code; PA_PROJECTS_ALL; PA_TASKS

APPS.PA_DRAFT_INVOICE_LINES_V is not referenced by any database object