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_RETN_INVOICE_DETAILS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

11i Retention View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	PROJECT_ID
DRAFT_INVOICE_NUM	NUMBER	(15)	Yes	DRAFT_INVOICE_NUM
LINE_NUM	NUMBER	(15)	Yes	LINE_NUM
PROJECT_RETENTION_ID	NUMBER	(15)	Yes	PROJECT_RETENTION_ID
RETENTION_RULE_ID	NUMBER	(15)	Yes	RETENTION_RULE_ID
TOTAL_RETAINED	NUMBER			TOTAL_RETAINED
PROJECT_TOTAL_RETAINED	NUMBER			PROJECT_TOTAL_RETAINED
FUNDING_TOTAL_RETAINED	NUMBER			FUNDING_TOTAL_RETAINED
TASK_NAME	VARCHAR2	(46)		TASK_NAME
EXPENDITURE_CATEGORY	VARCHAR2	(30)		EXPENDITURE_CATEGORY
EXPENDITURE_TYPE	VARCHAR2	(30)		EXPENDITURE_TYPE
REVENUE_CATEGORY_CODE	VARCHAR2	(30)		REVENUE_CATEGORY_CODE
REVENUE_CATEGORY_NAME	VARCHAR2	(80)		REVENUE_CATEGORY_NAME
EVENT_TYPE	VARCHAR2	(30)		EVENT_TYPE
NON_LABOR_RESOURCE	VARCHAR2	(30)		NON_LABOR_RESOURCE
EFFECTIVE_START_DATE	DATE		Yes	EFFECTIVE_START_DATE
EFFECTIVE_END_DATE	DATE			EFFECTIVE_END_DATE
RETENTION_PERCENTAGE	NUMBER			RETENTION_PERCENTAGE
RETENTION_AMOUNT	NUMBER			RETENTION_AMOUNT
PROJFUNC_TOTAL_RETAINED	NUMBER			PROJFUNC_TOTAL_RETAINED
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.

Query Text

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


SELECT PROJECT_ID
,      DRAFT_INVOICE_NUM
,      LINE_NUM
,      PROJECT_RETENTION_ID
,      RETENTION_RULE_ID
,      TOTAL_RETAINED
,      PROJECT_TOTAL_RETAINED
,      FUNDING_TOTAL_RETAINED
,      TASK_NAME
,      EXPENDITURE_CATEGORY
,      EXPENDITURE_TYPE
,      REVENUE_CATEGORY_CODE
,      REVENUE_CATEGORY_NAME
,      EVENT_TYPE
,      NON_LABOR_RESOURCE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RETENTION_PERCENTAGE
,      RETENTION_AMOUNT
,      PROJFUNC_TOTAL_RETAINED
,      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
FROM APPS.PA_RETN_INVOICE_DETAILS_V;

Dependencies

[top of page]

APPS.PA_RETN_INVOICE_DETAILS_V references the following:

APPS: PA_DRAFT_INVOICES_ALL; PA_DRAFT_INVOICE_ITEMS; PA_LOOKUPS; PA_PROJECT_RETENTIONS; PA_PROJ_RETN_RULES; PA_RETN_INVOICE_DETAILS; PA_TASKS

APPS.PA_RETN_INVOICE_DETAILS_V is not referenced by any database object