[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
|
|
|