VIEW: APPS.PA_AMG_RESOURCE_INFO_V

Source

View Text - Preformatted

SELECT 'MSPROJECT' product_code , base.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 , base.standard_rate standard_rate,base.migration_code, base.resource_list_id FROM PA_AMG_RESOURCE_INFO_BASE_V base

View Text - HTML Formatted

SELECT 'MSPROJECT' PRODUCT_CODE
, BASE.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
, BASE.STANDARD_RATE STANDARD_RATE
, BASE.MIGRATION_CODE
, BASE.RESOURCE_LIST_ID
FROM PA_AMG_RESOURCE_INFO_BASE_V BASE