Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_AMG_RESOURCE_INFO_BASE_V |
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