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_AMG_RESOURCE_INFO_BASE_V

Object Details

Object Name:	PA_AMG_RESOURCE_INFO_BASE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_AMG_RESOURCE_INFO_BASE_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
PRODUCT_CODE	CHAR	(9)
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes
POPULATE_TEXT3_COL_FLAG	CHAR	(1)
TEXT3	VARCHAR2	(0)
POPULATE_TEXT4_COL_FLAG	CHAR	(1)
TEXT4	VARCHAR2	(0)
POPULATE_TEXT5_COL_FLAG	CHAR	(1)
TEXT5	VARCHAR2	(0)
POPULATE_TEXT6_COL_FLAG	CHAR	(1)
TEXT6	VARCHAR2	(0)
POPULATE_COST1_COL_FLAG	CHAR	(1)
COST1	VARCHAR2	(0)
POPULATE_COST2_COL_FLAG	CHAR	(1)
COST2	VARCHAR2	(0)
POPULATE_COST3_COL_FLAG	CHAR	(1)
COST3	VARCHAR2	(0)
POPULATE_COST4_COL_FLAG	CHAR	(1)
COST4	VARCHAR2	(0)
POPULATE_OVERTIME_RT_COL_FLAG	CHAR	(1)
OVERTIME_RATE	VARCHAR2	(0)
POPULATE_COST_PER_USE_COL_FLAG	CHAR	(1)
COST_PER_USE	VARCHAR2	(0)
POPULATE_STANDARD_RT_COL_FLAG	CHAR	(1)
STANDARD_RATE	NUMBER
MIGRATION_CODE	VARCHAR2	(1)
RESOURCE_LIST_ID	NUMBER	(15)	Yes

Query Text

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


SELECT PRODUCT_CODE
,      RESOURCE_LIST_MEMBER_ID
,      POPULATE_TEXT3_COL_FLAG
,      TEXT3
,      POPULATE_TEXT4_COL_FLAG
,      TEXT4
,      POPULATE_TEXT5_COL_FLAG
,      TEXT5
,      POPULATE_TEXT6_COL_FLAG
,      TEXT6
,      POPULATE_COST1_COL_FLAG
,      COST1
,      POPULATE_COST2_COL_FLAG
,      COST2
,      POPULATE_COST3_COL_FLAG
,      COST3
,      POPULATE_COST4_COL_FLAG
,      COST4
,      POPULATE_OVERTIME_RT_COL_FLAG
,      OVERTIME_RATE
,      POPULATE_COST_PER_USE_COL_FLAG
,      COST_PER_USE
,      POPULATE_STANDARD_RT_COL_FLAG
,      STANDARD_RATE
,      MIGRATION_CODE
,      RESOURCE_LIST_ID
FROM APPS.PA_AMG_RESOURCE_INFO_BASE_V;

Dependencies

[top of page]

APPS.PA_AMG_RESOURCE_INFO_BASE_V references the following:

APPS: PA_RESOURCE_LIST_MEMBERS

APPS.PA_AMG_RESOURCE_INFO_BASE_V is referenced by following:

APPS: PA_AMG_RESOURCE_INFO_V