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_INVOICES_V

Object Details

Object Name:	PA_DRAFT_INVOICES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_DRAFT_INVOICES_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	Mandatory	Comments
ROW_ID	ROWID	(10)
PROJECT_ID	NUMBER	(15)	Yes
PROJECT_NUMBER	VARCHAR2	(25)	Yes
PROJECT_NAME	VARCHAR2	(30)	Yes
DISTRIBUTION_RULE	VARCHAR2	(30)
DISTRIBUTION_RULE_M	VARCHAR2	(80)
PROJECT_TYPE	VARCHAR2	(20)	Yes
PROJECT_STATUS_M	VARCHAR2	(80)
PROJECT_STATUS_CODE	VARCHAR2	(30)	Yes
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Yes
PROJECT_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
CUSTOMER_ID	NUMBER	(15)	Yes
CUSTOMER_NAME	VARCHAR2	(360)	Yes
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
AGREEMENT_ID	NUMBER	(15)	Yes
AGREEMENT_NUM	VARCHAR2	(50)	Yes
AGREEMENT_TYPE	VARCHAR2	(30)	Yes
TERM_ID	NUMBER	(15)	Yes
TERM_NAME	VARCHAR2	(15)
DRAFT_INVOICE_NUM	NUMBER	(15)	Yes
TRANSFER_STATUS_CODE	VARCHAR2	(1)	Yes
INVOICE_STATUS_CODE	VARCHAR2	(30)	Yes
INVOICE_STATUS_M	VARCHAR2	(80)	Yes
CHK_STATUS	VARCHAR2	(11)
BILL_THROUGH_DATE	DATE
APPROVED_DATE	DATE
APPROVED_BY_PERSON_ID	NUMBER	(9)
APPROVED_BY_PERSON_NAME	VARCHAR2	(240)
APPROVED_BY_PERSON_NUMBER	VARCHAR2	(30)
RELEASED_DATE	DATE
RELEASED_BY_PERSON_ID	NUMBER	(9)
RELEASED_BY_PERSON_NAME	VARCHAR2	(240)
RELEASED_BY_PERSON_NUMBER	VARCHAR2	(30)
INVOICE_DATE	DATE
RA_INVOICE_NUMBER	VARCHAR2	(20)
PA_DATE	DATE
GL_DATE	DATE
CREATION_DATE	DATE		Yes	Standard Who Column
INVOICE_COMMENT	VARCHAR2	(240)
DRAFT_INVOICE_NUM_CREDITED	NUMBER	(15)
CANCELED_FLAG	VARCHAR2	(1)
CANCEL_CREDIT_MEMO_FLAG	VARCHAR2	(1)
WRITE_OFF_FLAG	VARCHAR2	(1)
CONVERTED_FLAG	VARCHAR2	(1)
EXTRACTED_DATE	DATE
RETENTION_PERCENTAGE	NUMBER	(15)
RA_INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Invoice currency code populated from Oracle Receivables
INV_CURRENCY_CODE	VARCHAR2	(15)		Invoice currency code for the draft invoice that is transferred to Oracle Receivables
INV_RATE_TYPE	VARCHAR2	(30)		Invoice currency exchange rate type for the draft invoice that is transferred to Oracle Receivables
INV_RATE_DATE	DATE			Invoice currency exchange rate date for the draft invoice that is transferred to Oracle Receivables
INV_EXCHANGE_RATE	NUMBER			Invoice currency exchange rate for the draft invoice that is transferred to Oracle Receivables
INV_USER_RATE_TYPE	VARCHAR2	(30)		Invoice User currency exchange rate type for the draft invoice that is transferred to Oracle Receivables
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Yes
INVOICE_CLASS	VARCHAR2	(80)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		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
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
GENERATION_ERROR_FLAG	VARCHAR2	(1)	Yes
TRANSFERRED_DATE	DATE
TRANSFER_REJECTION_REASON	VARCHAR2	(250)
EXCEPTION_FLAG	VARCHAR2	(1)
UNEARNED_REVENUE_CR	NUMBER
UNBILLED_RECEIVABLE_DR	NUMBER
SYSTEM_REFERENCE	NUMBER	(15)
CUSTOMER_BILL_SPLIT	NUMBER	(7)
INVOICE_SET_ID	NUMBER	(15)
INVOICE_AMOUNT	NUMBER
AMOUNT	NUMBER
ORIGINAL_BALANCE	NUMBER
BALANCE_DUE	NUMBER
AMOUNT_APPLIED	VARCHAR2	(0)
AMOUNT_CREDITED	VARCHAR2	(0)
WRITE_OFF	VARCHAR2	(0)
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
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
BILL_TO_ADDRESS_ID	NUMBER
SHIP_TO_ADDRESS_ID	NUMBER
UPDATE_ALLOWED	VARCHAR2	(4000)
VIEW_LABOR_COSTS_ALLOWED	VARCHAR2	(4000)
RECEIVABLE_CODE_COMBINATION_ID	NUMBER
ROUNDING_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the rounding amount is charged. This column is populated in Transfer Invoice to Receivable program from Release 11.5.
UNBILLED_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the unbilled receivable amount is charged. This column is populated in Transfer Invoice to Receivable program from Release 11.5.
UNEARNED_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the unearned revenue amount is charged.This column is populated in Transfer Invoice to Receivable program from Release 11.5.
WOFF_CODE_COMBINATION_ID	NUMBER			The identifier of the GL account to which the write-off amount is charged. This column is populated in Transfer Invoice to Receivable program from Release 11.5.
RECV_INV_AMT	NUMBER
ROUND_AMT	NUMBER
LANGUAGE	VARCHAR2	(30)
NLS_LANGUAGE	VARCHAR2	(30)
ACCTD_CURR_CODE	VARCHAR2	(15)
ACCTD_RATE_TYPE	VARCHAR2	(30)
ACCTD_RATE_DATE	DATE
ACCTD_EXCHG_RATE	NUMBER
TAX_AMOUNT	NUMBER
INVOICE_CATEGORY	VARCHAR2	(21)
INVOICE_BATCH_SOURCE_ID	NUMBER	(15)
CC_IC_AR_BATCH_SOURCE_ID	NUMBER	(20)
CC_PROJECT_ID	NUMBER
IB_AP_TRANSFER_STATUS_CODE	VARCHAR2	(1)
IB_AP_TRANSFER_ERROR_CODE	VARCHAR2	(80)
INVPROC_CURRENCY_CODE	VARCHAR2	(15)		The Invoice processing.
INVPROC_BILL_AMOUNT	NUMBER			Invoice amount in Invoice processing currency.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		The Project Functional Currency.
PROJFUNC_BILL_AMOUNT	NUMBER			Invoice amount in Project Functional currency.
PROJ_BILL_AMOUNT	NUMBER			Invoice amount in Project currency.
FUNDING_CURRENCY_CODE	VARCHAR2	(15)		The Funding Currency.
FUNDING_BILL_AMOUNT	NUMBER			Invoice amount in Funding Currency.
PROJFUNC_INVTRANS_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from project punctional currency to invoice transaction currency
PROJFUNC_INVTRANS_RATE_TY_NAME	VARCHAR2	(4000)		Exchange User rate type to use for conversion from project punctional currency to invoice transaction currency
PROJFUNC_INVTRANS_RATE_DATE	DATE			Exchange rate date to use for conversion from project punctional currency to invoice transaction currency
PROJFUNC_INVTRANS_EX_RATE	NUMBER			Exchange rate to use for conversion from project functional currency to invoice transaction currency
RETENTION_INVOICE_FLAG	VARCHAR2	(1)		This indicates whether the invoice is retention invoice or not
RETN_CODE_COMBINATION_ID	NUMBER			Retention account code combination Id. This is generated based on the auto accounting rules
CREDIT_MEMO_REASON_CODE	VARCHAR2	(30)		Credit Memo Reason Code is used while releasing invoices of Credit memo invoice class
BILL_TO_CUSTOMER_ID	NUMBER	(15)		Customer Id of the Bill to Customer
SHIP_TO_CUSTOMER_ID	NUMBER	(15)		Customer Id of the Ship to Customer
BILL_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		Customer Number of the Ship to Customer
BILL_TO_CUSTOMER_NAME	VARCHAR2	(360)		Customer Name of the Ship to Customer
SHIP_TO_CUSTOMER_NUMBER	VARCHAR2	(30)
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(360)
CONCESSION_FLAG	VARCHAR2	(1)
RECORD_VERSION_NUMBER	NUMBER
LAST_CREDIT_REQUEST_ID	NUMBER
ENABLE_TOP_TASK_INV_MTH_FLAG	VARCHAR2	(1)
REVENUE_ACCRUAL_METHOD	VARCHAR2	(30)
INVOICE_METHOD	VARCHAR2	(30)
REVENUE_ACCRUAL_METHOD_DISP	VARCHAR2	(80)
INVOICE_METHOD_DISP	VARCHAR2	(80)
BILL_TO_PARTY_ID	NUMBER	(15)		Party Id of the Bill to Customer
SHIP_TO_PARTY_ID	NUMBER	(15)		Party Id of the Ship to Customer
BILL_TO_SITE_USE_ID	NUMBER	(15)		Site use Id of the Bill to Customer
SHIP_TO_SITE_USE_ID	NUMBER	(15)		Site use Id of the Ship to Customer
CUSTOMER_ORDER_NUMBER	VARCHAR2	(240)		- Customer Order Number
LINE_OF_ACCOUNT	VARCHAR2	(240)		- Line Of Account
PAYMENT_SET_ID	NUMBER	(15)		- Payment Set ID

Query Text

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


SELECT ROW_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      DISTRIBUTION_RULE
,      DISTRIBUTION_RULE_M
,      PROJECT_TYPE
,      PROJECT_STATUS_M
,      PROJECT_STATUS_CODE
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_NAME
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      AGREEMENT_ID
,      AGREEMENT_NUM
,      AGREEMENT_TYPE
,      TERM_ID
,      TERM_NAME
,      DRAFT_INVOICE_NUM
,      TRANSFER_STATUS_CODE
,      INVOICE_STATUS_CODE
,      INVOICE_STATUS_M
,      CHK_STATUS
,      BILL_THROUGH_DATE
,      APPROVED_DATE
,      APPROVED_BY_PERSON_ID
,      APPROVED_BY_PERSON_NAME
,      APPROVED_BY_PERSON_NUMBER
,      RELEASED_DATE
,      RELEASED_BY_PERSON_ID
,      RELEASED_BY_PERSON_NAME
,      RELEASED_BY_PERSON_NUMBER
,      INVOICE_DATE
,      RA_INVOICE_NUMBER
,      PA_DATE
,      GL_DATE
,      CREATION_DATE
,      INVOICE_COMMENT
,      DRAFT_INVOICE_NUM_CREDITED
,      CANCELED_FLAG
,      CANCEL_CREDIT_MEMO_FLAG
,      WRITE_OFF_FLAG
,      CONVERTED_FLAG
,      EXTRACTED_DATE
,      RETENTION_PERCENTAGE
,      RA_INVOICE_CURRENCY_CODE
,      INV_CURRENCY_CODE
,      INV_RATE_TYPE
,      INV_RATE_DATE
,      INV_EXCHANGE_RATE
,      INV_USER_RATE_TYPE
,      PROJECT_CURRENCY_CODE
,      INVOICE_CLASS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      GENERATION_ERROR_FLAG
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      EXCEPTION_FLAG
,      UNEARNED_REVENUE_CR
,      UNBILLED_RECEIVABLE_DR
,      SYSTEM_REFERENCE
,      CUSTOMER_BILL_SPLIT
,      INVOICE_SET_ID
,      INVOICE_AMOUNT
,      AMOUNT
,      ORIGINAL_BALANCE
,      BALANCE_DUE
,      AMOUNT_APPLIED
,      AMOUNT_CREDITED
,      WRITE_OFF
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      UPDATE_ALLOWED
,      VIEW_LABOR_COSTS_ALLOWED
,      RECEIVABLE_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      UNBILLED_CODE_COMBINATION_ID
,      UNEARNED_CODE_COMBINATION_ID
,      WOFF_CODE_COMBINATION_ID
,      RECV_INV_AMT
,      ROUND_AMT
,      LANGUAGE
,      NLS_LANGUAGE
,      ACCTD_CURR_CODE
,      ACCTD_RATE_TYPE
,      ACCTD_RATE_DATE
,      ACCTD_EXCHG_RATE
,      TAX_AMOUNT
,      INVOICE_CATEGORY
,      INVOICE_BATCH_SOURCE_ID
,      CC_IC_AR_BATCH_SOURCE_ID
,      CC_PROJECT_ID
,      IB_AP_TRANSFER_STATUS_CODE
,      IB_AP_TRANSFER_ERROR_CODE
,      INVPROC_CURRENCY_CODE
,      INVPROC_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_BILL_AMOUNT
,      PROJ_BILL_AMOUNT
,      FUNDING_CURRENCY_CODE
,      FUNDING_BILL_AMOUNT
,      PROJFUNC_INVTRANS_RATE_TYPE
,      PROJFUNC_INVTRANS_RATE_TY_NAME
,      PROJFUNC_INVTRANS_RATE_DATE
,      PROJFUNC_INVTRANS_EX_RATE
,      RETENTION_INVOICE_FLAG
,      RETN_CODE_COMBINATION_ID
,      CREDIT_MEMO_REASON_CODE
,      BILL_TO_CUSTOMER_ID
,      SHIP_TO_CUSTOMER_ID
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_NAME
,      SHIP_TO_CUSTOMER_NUMBER
,      SHIP_TO_CUSTOMER_NAME
,      CONCESSION_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_CREDIT_REQUEST_ID
,      ENABLE_TOP_TASK_INV_MTH_FLAG
,      REVENUE_ACCRUAL_METHOD
,      INVOICE_METHOD
,      REVENUE_ACCRUAL_METHOD_DISP
,      INVOICE_METHOD_DISP
,      BILL_TO_PARTY_ID
,      SHIP_TO_PARTY_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      CUSTOMER_ORDER_NUMBER
,      LINE_OF_ACCOUNT
,      PAYMENT_SET_ID
FROM APPS.PA_DRAFT_INVOICES_V;