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

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