VIEW: APPS.PA_AMG_RESOURCE_INFO_BASE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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