VIEW: APPS.IGW_PRPO_PERSON_DETAILS_V

Source

View Text - Preformatted

SELECT 1 ,'last_name' , 'first_name' , 'middle_names' , 'proposal_role_code' , 'proposal_role' , 'period_type_code' , 'Academic' , 'budget_category_code' , 'budget_category' , to_date('01-01-00', 'DD:MM:YY') , to_date('31-12-10', 'DD:MM:YY') , 'appointment_type_code'  ,1 , 'DO' percent_dollar_flag , 1000 , 10 , to_number(null)  , to_number(null)  , 1 , 1000 , 1 , 1 , 1 from dual

View Text - HTML Formatted

SELECT 1
, 'LAST_NAME'
, 'FIRST_NAME'
, 'MIDDLE_NAMES'
, 'PROPOSAL_ROLE_CODE'
, 'PROPOSAL_ROLE'
, 'PERIOD_TYPE_CODE'
, 'ACADEMIC'
, 'BUDGET_CATEGORY_CODE'
, 'BUDGET_CATEGORY'
, TO_DATE('01-01-00'
, 'DD:MM:YY')
, TO_DATE('31-12-10'
, 'DD:MM:YY')
, 'APPOINTMENT_TYPE_CODE'
, 1
, 'DO' PERCENT_DOLLAR_FLAG
, 1000
, 10
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 1
, 1000
, 1
, 1
, 1
FROM DUAL