ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4A7C2E19B3D64F0E8C51A9D27E6B03F4Y select null action_, null status_, null message_, null modified_columns_, mp.organization_code, qp.name plan_name, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,1) char1, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,2) char2, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,3) char3, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,4) char4, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,5) char5, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,6) char6, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,7) char7, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,8) char8, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,9) char9, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,10) char10, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,11) char11, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,12) char12, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,13) char13, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,14) char14, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,15) char15, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,16) char16, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,17) char17, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,18) char18, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,19) char19, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,20) char20, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,21) char21, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,22) char22, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,23) char23, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,24) char24, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,25) char25, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,26) char26, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,27) char27, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,28) char28, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,29) char29, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,30) char30, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,31) char31, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,32) char32, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,33) char33, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,34) char34, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,35) char35, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,36) char36, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,37) char37, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,38) char38, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,39) char39, xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,40) char40, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,1) number1, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,2) number2, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,3) number3, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,4) number4, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,5) number5, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,6) number6, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,7) number7, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,8) number8, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,9) number9, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,10) number10, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,11) number11, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,12) number12, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,13) number13, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,14) number14, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,15) number15, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,16) number16, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,17) number17, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,18) number18, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,19) number19, xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,20) number20, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,1) date1, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,2) date2, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,3) date3, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,4) date4, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,5) date5, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,6) date6, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,7) date7, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,8) date8, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,9) date9, xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,10) date10, qr.occurrence, null upload_row from qa_plans qp, mtl_parameters mp, qa_results qr where 1=1 and qp.organization_id=:organization_id and qp.plan_id=:plan_id and qp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and qp.organization_id=mp.organization_id and qp.plan_id=qr.plan_id and (qr.status is null or qr.status=2) New upload for the results of any collection plan. U A xxen_qa_upload.collection_result US QA Collection Result Upload Enters and updates quality results of any collection plan, as the Enter Quality Results and Update Quality Results forms do, through the Oracle Quality results API with its element validations. The Plan parameter selects the collection plan. The plan's text and comment elements are shown in the columns Char1 to Char40, its number elements in Number1 to Number20 and its date elements in Date1 to Date10, each type in the plan's prompt sequence, with the column headings showing the element prompts. Columns without an element keep their generic heading and stay empty; hide them with a template per plan. Create, Update mode downloads the plan's existing results. An updated row writes only the element values that were changed, and Oracle records each in the result update history. Plans with actions, Sequence elements or Date and Time elements are not supported. Enginatics R12 only Upload 1=1 :organization_id :plan_id 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 :organization_id LOV custom select mp.organization_id id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and mp.organization_id in (select qp.organization_id from qa_plans qp) and mp.organization_id=haouv.organization_id order by mp.organization_code fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization 3 30 :plan_id LOV custom select qp.plan_id id, qp.name value, qp.description from qa_plans qp where qp.organization_id=:$flex$.organization and trunc(sysdate) between nvl(trunc(qp.effective_from),trunc(sysdate)) and nvl(trunc(qp.effective_to),trunc(sysdate)) order by qp.name Y US Plan Collection plan whose results are downloaded and uploaded. The element columns are mapped to this plan. 4 40 1=1 qr.creation_date>=:result_date_from Date US Result Date From Date the result was entered. 5 50 1=1 qr.creation_date<:result_date_to+1 Date last_day(:$flex$.result_date_from) US Result Date To Date the result was entered. 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORGANIZATION_CODE LOV custom varchar2 select mp.organization_id id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and mp.organization_id in (select qp.organization_id from qa_plans qp) and mp.organization_id=haouv.organization_id order by mp.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=:$flex$.organization Y Y 6 PLAN_NAME Char varchar2 select qp.name from qa_plans qp where qp.plan_id=:$flex$.plan Y Y 7 CHAR1 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR1')) x 8 CHAR2 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR2')) x 9 CHAR3 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR3')) x 10 CHAR4 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR4')) x 11 CHAR5 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR5')) x 12 CHAR6 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR6')) x 13 CHAR7 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR7')) x 14 CHAR8 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR8')) x 15 CHAR9 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR9')) x 16 CHAR10 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR10')) x 17 CHAR11 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR11')) x 18 CHAR12 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR12')) x 19 CHAR13 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR13')) x 20 CHAR14 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR14')) x 21 CHAR15 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR15')) x 22 CHAR16 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR16')) x 23 CHAR17 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR17')) x 24 CHAR18 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR18')) x 25 CHAR19 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR19')) x 26 CHAR20 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR20')) x 27 CHAR21 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR21')) x 28 CHAR22 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR22')) x 29 CHAR23 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR23')) x 30 CHAR24 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR24')) x 31 CHAR25 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR25')) x 32 CHAR26 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR26')) x 33 CHAR27 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR27')) x 34 CHAR28 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR28')) x 35 CHAR29 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR29')) x 36 CHAR30 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR30')) x 37 CHAR31 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR31')) x 38 CHAR32 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR32')) x 39 CHAR33 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR33')) x 40 CHAR34 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR34')) x 41 CHAR35 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR35')) x 42 CHAR36 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR36')) x 43 CHAR37 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR37')) x 44 CHAR38 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR38')) x 45 CHAR39 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR39')) x 46 CHAR40 LOV custom varchar2 Y select substrb(x.column_value,1,instrb(x.column_value,'~')-1) value, substrb(x.column_value,instrb(x.column_value,'~')+1) description from table(xxen_qa_upload.slot_lov(:$flex$.plan,'CHAR40')) x 47 NUMBER1 Number number 48 NUMBER2 Number number 49 NUMBER3 Number number 50 NUMBER4 Number number 51 NUMBER5 Number number 52 NUMBER6 Number number 53 NUMBER7 Number number 54 NUMBER8 Number number 55 NUMBER9 Number number 56 NUMBER10 Number number 57 NUMBER11 Number number 58 NUMBER12 Number number 59 NUMBER13 Number number 60 NUMBER14 Number number 61 NUMBER15 Number number 62 NUMBER16 Number number 63 NUMBER17 Number number 64 NUMBER18 Number number 65 NUMBER19 Number number 66 NUMBER20 Number number 67 DATE1 Date date 68 DATE2 Date date 69 DATE3 Date date 70 DATE4 Date date 71 DATE5 Date date 72 DATE6 Date date 73 DATE7 Date date 74 DATE8 Date date 75 DATE9 Date date 76 DATE10 Date date 77 OCCURRENCE Number number Y 78 UPLOAD_ROW Char varchar2 Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_organization_id in Number ORGANIZATION_CODE U 5 p_plan_name in Char PLAN_NAME U 6 p_occurrence in Number OCCURRENCE U 7 p_occurrence_out out Number OCCURRENCE U 8 p_char1 in Char Y CHAR1 U 9 p_char2 in Char Y CHAR2 U 10 p_char3 in Char Y CHAR3 U 11 p_char4 in Char Y CHAR4 U 12 p_char5 in Char Y CHAR5 U 13 p_char6 in Char Y CHAR6 U 14 p_char7 in Char Y CHAR7 U 15 p_char8 in Char Y CHAR8 U 16 p_char9 in Char Y CHAR9 U 17 p_char10 in Char Y CHAR10 U 18 p_char11 in Char Y CHAR11 U 19 p_char12 in Char Y CHAR12 U 20 p_char13 in Char Y CHAR13 U 21 p_char14 in Char Y CHAR14 U 22 p_char15 in Char Y CHAR15 U 23 p_char16 in Char Y CHAR16 U 24 p_char17 in Char Y CHAR17 U 25 p_char18 in Char Y CHAR18 U 26 p_char19 in Char Y CHAR19 U 27 p_char20 in Char Y CHAR20 U 28 p_char21 in Char Y CHAR21 U 29 p_char22 in Char Y CHAR22 U 30 p_char23 in Char Y CHAR23 U 31 p_char24 in Char Y CHAR24 U 32 p_char25 in Char Y CHAR25 U 33 p_char26 in Char Y CHAR26 U 34 p_char27 in Char Y CHAR27 U 35 p_char28 in Char Y CHAR28 U 36 p_char29 in Char Y CHAR29 U 37 p_char30 in Char Y CHAR30 U 38 p_char31 in Char Y CHAR31 U 39 p_char32 in Char Y CHAR32 U 40 p_char33 in Char Y CHAR33 U 41 p_char34 in Char Y CHAR34 U 42 p_char35 in Char Y CHAR35 U 43 p_char36 in Char Y CHAR36 U 44 p_char37 in Char Y CHAR37 U 45 p_char38 in Char Y CHAR38 U 46 p_char39 in Char Y CHAR39 U 47 p_char40 in Char Y CHAR40 U 48 p_number1 in Number Y NUMBER1 U 49 p_number2 in Number Y NUMBER2 U 50 p_number3 in Number Y NUMBER3 U 51 p_number4 in Number Y NUMBER4 U 52 p_number5 in Number Y NUMBER5 U 53 p_number6 in Number Y NUMBER6 U 54 p_number7 in Number Y NUMBER7 U 55 p_number8 in Number Y NUMBER8 U 56 p_number9 in Number Y NUMBER9 U 57 p_number10 in Number Y NUMBER10 U 58 p_number11 in Number Y NUMBER11 U 59 p_number12 in Number Y NUMBER12 U 60 p_number13 in Number Y NUMBER13 U 61 p_number14 in Number Y NUMBER14 U 62 p_number15 in Number Y NUMBER15 U 63 p_number16 in Number Y NUMBER16 U 64 p_number17 in Number Y NUMBER17 U 65 p_number18 in Number Y NUMBER18 U 66 p_number19 in Number Y NUMBER19 U 67 p_number20 in Number Y NUMBER20 U 68 p_date1 in Date Y DATE1 U 69 p_date2 in Date Y DATE2 U 70 p_date3 in Date Y DATE3 U 71 p_date4 in Date Y DATE4 U 72 p_date5 in Date Y DATE5 U 73 p_date6 in Date Y DATE6 U 74 p_date7 in Date Y DATE7 U 75 p_date8 in Date Y DATE8 U 76 p_date9 in Date Y DATE9 U 77 p_date10 in Date Y DATE10 Error SQL Order By upload_row, occurrence Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(mp.organization_code,xu.organization_code) organization_code, nvl(qp.name,xu.plan_name) plan_name, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,1),xu.char1) char1, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,2),xu.char2) char2, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,3),xu.char3) char3, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,4),xu.char4) char4, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,5),xu.char5) char5, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,6),xu.char6) char6, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,7),xu.char7) char7, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,8),xu.char8) char8, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,9),xu.char9) char9, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,10),xu.char10) char10, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,11),xu.char11) char11, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,12),xu.char12) char12, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,13),xu.char13) char13, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,14),xu.char14) char14, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,15),xu.char15) char15, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,16),xu.char16) char16, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,17),xu.char17) char17, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,18),xu.char18) char18, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,19),xu.char19) char19, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,20),xu.char20) char20, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,21),xu.char21) char21, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,22),xu.char22) char22, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,23),xu.char23) char23, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,24),xu.char24) char24, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,25),xu.char25) char25, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,26),xu.char26) char26, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,27),xu.char27) char27, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,28),xu.char28) char28, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,29),xu.char29) char29, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,30),xu.char30) char30, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,31),xu.char31) char31, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,32),xu.char32) char32, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,33),xu.char33) char33, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,34),xu.char34) char34, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,35),xu.char35) char35, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,36),xu.char36) char36, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,37),xu.char37) char37, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,38),xu.char38) char38, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,39),xu.char39) char39, nvl(xxen_qa_upload.result_char(qr.plan_id,qr.occurrence,qr.last_update_date,40),xu.char40) char40, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,1),xu.number1) number1, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,2),xu.number2) number2, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,3),xu.number3) number3, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,4),xu.number4) number4, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,5),xu.number5) number5, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,6),xu.number6) number6, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,7),xu.number7) number7, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,8),xu.number8) number8, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,9),xu.number9) number9, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,10),xu.number10) number10, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,11),xu.number11) number11, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,12),xu.number12) number12, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,13),xu.number13) number13, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,14),xu.number14) number14, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,15),xu.number15) number15, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,16),xu.number16) number16, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,17),xu.number17) number17, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,18),xu.number18) number18, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,19),xu.number19) number19, nvl(xxen_qa_upload.result_number(qr.plan_id,qr.occurrence,qr.last_update_date,20),xu.number20) number20, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,1),xu.date1) date1, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,2),xu.date2) date2, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,3),xu.date3) date3, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,4),xu.date4) date4, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,5),xu.date5) date5, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,6),xu.date6) date6, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,7),xu.date7) date7, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,8),xu.date8) date8, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,9),xu.date9) date9, nvl(xxen_qa_upload.result_date(qr.plan_id,qr.occurrence,qr.last_update_date,10),xu.date10) date10, xu.occurrence, xu.upload_row from xxen_qa_collection_resu_5925_u xu, qa_results qr, qa_plans qp, mtl_parameters mp where xu.status_code_=xxen_upload.status_success and xu.occurrence=qr.occurrence(+) and nvl(qr.status(+),2)=2 and qr.plan_id=qp.plan_id(+) and qp.organization_id=mp.organization_id(+)