FND Design Data [Home] [Help]

View: PA_AMG_RESOURCE_INFO_BASE_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_AMG_RESOURCE_INFO_BASE_V
View Text

SELECT 'MSPROJECT' PRODUCT_CODE
, A.RESOURCE_LIST_MEMBER_ID
, 'N' POPULATE_TEXT3_COL_FLAG
, NULL TEXT3
, 'N' POPULATE_TEXT4_COL_FLAG
, NULL TEXT4
, 'N' POPULATE_TEXT5_COL_FLAG
, NULL TEXT5
, 'N' POPULATE_TEXT6_COL_FLAG
, NULL TEXT6
, 'N' POPULATE_COST1_COL_FLAG
, NULL COST1
, 'N' POPULATE_COST2_COL_FLAG
, NULL COST2
, 'N' POPULATE_COST3_COL_FLAG
, NULL COST3
, 'N' POPULATE_COST4_COL_FLAG
, NULL COST4
, 'N' POPULATE_OVERTIME_RT_COL_FLAG
, NULL OVERTIME_RATE
, 'N' POPULATE_COST_PER_USE_COL_FLAG
, NULL COST_PER_USE
, 'Y' POPULATE_STANDARD_RT_COL_FLAG
, 0.0 STANDARD_RATE
, A.MIGRATION_CODE
, A.RESOURCE_LIST_ID
FROM PA_RESOURCE_LIST_MEMBERS A

Columns

Name
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