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.PAFV_CUSTOMER_INVOICES

Object Details

Object Name:	PAFV_CUSTOMER_INVOICES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PAFV_CUSTOMER_INVOICES
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

A Business Intelligence System view

This shows information about draft invoices generated for a project.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Unique identifier for Project
DRAFT_INVOICE_NUM	NUMBER	(15)	Yes	Draft Invoice Number
APPROVED_DATE	DATE			Approved Date
RELEASED_DATE	DATE			Released Date
INVOICE_DATE	DATE			Invoice Date
UNEARNED_REVENUE_CR	NUMBER	(22)		Unearned Revenue Credit
UNBILLED_RECEIVABLE_DR	NUMBER	(22)		Unbilled Receivable Debit
_LA:TRANSFER_STATUS	CHAR	(63)		Transfer Status
_LA:GENERATION_ERROR_FLAG	CHAR	(56)		Generation Error flag
BILL_THROUGH_DATE	DATE			Bill Through Date
INVOICE_COMMENT	VARCHAR2	(240)		Invoice Comment
AR_INVOICE_NUMBER	VARCHAR2	(20)		Account Receivables Invoice Number
TRANSFERRED_DATE	DATE			Transferred Date
TRANSFER_REJECTION_REASON	VARCHAR2	(250)		Transfer Rejection Reason
GL_DATE	DATE			General Ledger Date
INVOICE_CLASS	VARCHAR2	(80)	Yes	Invoice Class
TRX_NUMBER	VARCHAR2	(20)		Transaction Number
TRX_DATE	DATE			Transaction Date
_DF	CHAR	(38)		Descriptive Flexfield
AGREEMENT_ID	NUMBER	(15)	Yes	Unique identifier for Agreement
APPROVED_BY_PERSON_ID	NUMBER	(9)		Unique identifier for Approved By Person
APPROVED_BY_PERSON_NAME	VARCHAR2	(240)		Approved By Person Name
RELEASED_BY_PERSON_ID	NUMBER	(9)		Unique identifier for Released By Person
RELEASED_BY_PERSON_NAME	VARCHAR2	(240)		Released By Person Name
AGREEMENT_DESCRIPTION	VARCHAR2	(240)		Agreement Description
CUSTOMER_TRX_ID	NUMBER	(15)		Unique identifier for Customer Transaction
DRAFT_INVOICE_NUMBER_CREDITED	NUMBER	(15)		Draft Invoice Number Credited
ORG_ID	NUMBER	(15)		Unique identifier for Organization
ORGANIZATION_NAME	VARCHAR2	(240)		Organization Name
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.

Query Text

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


SELECT PROJECT_ID
,      DRAFT_INVOICE_NUM
,      APPROVED_DATE
,      RELEASED_DATE
,      INVOICE_DATE
,      UNEARNED_REVENUE_CR
,      UNBILLED_RECEIVABLE_DR
,      _LA:TRANSFER_STATUS
,      _LA:GENERATION_ERROR_FLAG
,      BILL_THROUGH_DATE
,      INVOICE_COMMENT
,      AR_INVOICE_NUMBER
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      GL_DATE
,      INVOICE_CLASS
,      TRX_NUMBER
,      TRX_DATE
,      _DF
,      AGREEMENT_ID
,      APPROVED_BY_PERSON_ID
,      APPROVED_BY_PERSON_NAME
,      RELEASED_BY_PERSON_ID
,      RELEASED_BY_PERSON_NAME
,      AGREEMENT_DESCRIPTION
,      CUSTOMER_TRX_ID
,      DRAFT_INVOICE_NUMBER_CREDITED
,      ORG_ID
,      ORGANIZATION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PAFV_CUSTOMER_INVOICES;

Dependencies

[top of page]

APPS.PAFV_CUSTOMER_INVOICES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; PA_AGREEMENTS_ALL; PA_DRAFT_INVOICES_ALL; PA_LOOKUPS; PA_PROJECTS_ALL; PER_ALL_PEOPLE_F; RA_CUSTOMER_TRX_ALL

APPS.PAFV_CUSTOMER_INVOICES is not referenced by any database object