srjava.util.Vectorٗ}[;IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xpur[Ljava.lang.Object;Xs)lxp(srInfoPurple.Qlet ඳcTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;xppppsq~$uq~(t EUL Reportpt100tManualt1440t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xp޸pppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA ptArialxsq~pppt15tYsq~pppsq~A@ ptArialxsq~lpppt dd-MMM-yyyyt #########tq0q~sq~A pq~xq~ tappst No_PatterntVLETsq~pppq~tXXDISCOVERER_ADMINsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp%tAuthor,Description etcq~t1000tDEFAULTtYppppxpsrInfoPurple.Plet ඳcL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.PointĊr4~&IxIyxp7srjava.awt.DimensionA׬_DIheightIwidthxp2wsq~uq~(t BA Name likesrdbUtil.dbInstance ඳcLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xptoracle.jdbc.driver.OracleDrivert welcome123tRudraSoft:1521:orcltsystemtALLt'%'t'ID1't'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xppt%tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp36tNtYtAuthor,Description etctYt1ppppppppppppppppppxt FROM dualsq~4sq~67sq~82sq~uq~(tWorkbook Name Likeq~>tALLt'%'t'ID1't'ID2't'ID3't'ID4't'ID5'sq~Jpt%tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp37tNtYtAuthor,Description etctYt1ppppppppppppppppppxt FROM dualsq~4sq~6sq~82sq~uq~(t EUL Ownerq~>tALLtdistinct ownert'ID1't'ID2't'ID3't'ID4't'ID5'sq~JptSYSTEMtID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp32tNq~tAuthor,Description etctYt1ppppppppppppppppppxt-from all_tables where table_name like 'EUL%' sq~4sq~6hsq~82dsq~uq~(t Tablel Prefixq~>tALLtdistinct substr(table_name,1,4)t'ID1't'ID2't'ID3't'ID4't'ID5'sq~JptEUL5tID1tID2tID3tID4tID5pq~sq~pppsq~A@ ptArialxtappstNONEtPLETtp33tNq~tAuthor,Description etctYt1ppppppppppppppppppxtqfrom all_tables where table_name like 'EUL%' and owner = 'G_PARAM' /*distinctowner*/ sq~4sq~66sq~82sq~uq~(t BA Creatorq~>tALLtdistinct ba_created_byt ba_created_byt'ID2't'ID3't'ID4't'ID5'sq~Jpt ALL Valuest%q~q~q~tALLpsq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp34tYtNtAuthor,Description etctYt1ppppppppppppppppppxt3 from G_PARAM.G_PARAM_bassq~4sq~69sq~82sq~uq~(tWorkbook Creatorq~>tALLtdistinct created_byt created_byt'ID2't'ID3't'ID4't'ID5'sq~Jpq~q~q~q~q~q~pq~sq~pppsq~A@ ptArialxtappstNONEtPLETtp35tYtNtAuthor,Description etctYt1ppppppppppppppppppxtfrom ( SELECT decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) created_by FROM G_PARAM.G_PARAM_documents o100588 WHERE (o100588.doc_content_type = 'application/vnd.oracle-disco.wb') AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') ) sq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~t>THEVERSIONOFTHEEULYOUARECURRENTLYUSINGIS-||O100624.VER_RELEASEt422sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A pq~ xt>Theversionoftheeulyouarecurrentlyusingis-||o100624.ver ReleasetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tVersiont364q~q~q~ t1q~q~ tNAtNt ##########t dd-MMM-yyyyq~q~tVersiontDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget450sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~6N}sq~8Rdsq~$uq~(tVersionq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~@q~!q~"q~$t dd-MMM-yyyyt #########tq47q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYt2tDEFAULTtYppppxthSELECT O100624.VER_RELEASE "Version" FROM G_PARAM.G_PARAM_VERSIONS O100624 sq~sq~uq~ sq~sq~uq~tXXLS_APPS_EUL_USt122sq~pppsq~@@@pppsq~pppt1q~[sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~_xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tInfoCaptor Messaget450sq~޸pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~tNOt30q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Rsq~sq~uq~t PARAMETERt145q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxpq~Rsq~sq~uq~tVALUEt287q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxpq~Rpppppxsq~6nsq~8sq~$uq~(t Parametersq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq147q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~t1tDEFAULTtYppppxtselect * from ( select 2 No, 'EUL Owner' Parameter, 'G_PARAM' Value from dual union select 3, 'EUL Prefix', 'G_PARAM' /*distinctsubstr(table_name,1,4)*/ from dual union select 4, 'Workbook Creator', 'G_PARAM' /*distinctcreated_by*/ from dual union select 5, 'BA Creator', 'G_PARAM' /*distinctba_created_by*/ from dual union select 1,'Date/Time', 'Report generated on '||to_char(sysdate,'dd-MON-yyyy hh:mi:ss') from dual ) order by nosq~sq~uq~ sq~sq~uq~tInfoCaptor Messaget450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t PRIVLEGESt75q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t PrivlegestDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~6!sq~8sq~$uq~(t Privilegesq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq96q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~KtAuthor,Description etctYq~1tDEFAULTtYppppxt SELECT decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username)), o100591.eu_username) user_role_responsibility ,decode(o100573.app_name_mn, 2300, 'User Edition', 2301, ' Create/Edit Query', 2302, ' Item Drill', 2303, ' Drill Out', 2304, ' Grant Workbook', 2305, ' Collect Query Statistics', 2306, 'Administration', 2307, ' Set Privilege', 2308, ' Create/Edit Business Area', 2309, ' Format Business Area', 2310, ' Create Summaries', 2311, ' Query Statistics Minimum Cost', 2312, ' Schedule Workbooks', 2313, 'Scheduled Workbooks Tab' || CHR(10) || ' Run Queries Online', 2314, ' Save Workbooks to Database', 2315, ' Manage Scheduled Workbooks', 2318, ' Change Password', 2317, ' Create Link', NULL, NULL, 'Unknown Privlege') privleges , decode(o100573.app_description_mn, 2400, 'Ability to use Oracle Discoverer User Edition', 2401, 'Ability to create new worksheets or edit existing ones. Without this option, a user only has the ability to run predefined worksheets', 2402, 'Ability to use item drills, drill to related items and drill from summary to detail items (hyperdrill) within Oracle Discoverer User Edition', 2403, 'Ability to drill out to launch other applications from Oracle Discoverer User Edition', 2404, 'Ability to grant access to workbooks to other users', 2405, 'Determines if running queries in Oracle Discoverer will then collect performance statistics', 2406, 'Ability to use Oracle Discoverer Administration Edition', 2407, 'Ability to grant and revoke End User Layer (TM) privileges', 2408, 'Ability to create new business areas and edit existing ones', 2409, 'Ability to edit only the formatting information in an existing business area', 2410, 'Ability to create summary tables', 2411, 'The minimum cost of query statistics to be recorded', 2412, 'Ability to Create and Edit Shedule Workbooks', 2413, 'Scheduling Repository must be enabled to run queries offline.' || CHR(10) || 'Ability to always run queries online. Without this option, the user can only schedule the workbook.', 2414, 'Ability to save workbooks to the database', 2415, 'Ability to maintain the scheduled workbooks of end-users', 2418, 'Ability to change password on current connection', 2417, 'Ability to create links in workbooks', NULL, NULL, 'Unknown Privlege') privilege_description FROM G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_app_params o100573, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100573.app_id = o100572.gp_app_id) AND(o100591.eu_id(+) = o100572.ap_eu_id)) AND(o100573.app_id <> 1018) AND(o100572.gba_ba_id IS NULL) ORDER BY 1, decode(o100573.app_name_mn, 2306, 1, 2309, 2, 2308, 3, 2310, 4, 2307, 5, 2315, 6, 2300, 7, 2301, 8, 2305, 9, 2302, 10, 2303, 11, 2304, 12, 2312, 13, 2314, 14, 2318, 15, 2313, 17, 2317, 16, 99) ASC sq~sq~uq~ sq~sq~uq~tInfoCaptor Messaget450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t BASE_OBJECTt267q~q~q~t1q~q~ tNAtNt ##########t dd-MMM-yyyyq~q~t Base ObjecttDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~6qsq~8Usq~$uq~(tFolder Filtersq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~-q~!q~"q~$t dd-MMM-yyyyt #########tq86q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~1tDEFAULTtYppppxtSELECT decode(o100592.exp_type, 'FIL', (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)), NULL) used_in_condition, decode(o100592.exp_type, 'FIL', NULL, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id))) item, o100577.ba_name , G_PARAM.G_PARAM_get_object(o100593.ped_exp_id) base_object, o100592_2.exp_name filter_name, decode(o100592_2.fil_runtime_filter, 0, 'Mandatory', 'Optional') filter_type, o100607_2.obj_name folder_name FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_expressions o100592_2, G_PARAM.G_PARAM_exp_deps o100593, G_PARAM.G_PARAM_objs o100607_2 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) AND(o100592_2.exp_id = o100593.pd_p_id) AND(o100607_2.obj_id = o100592_2.fil_obj_id) AND(o100607.obj_id = o100607_2.obj_id) AND(o100593.ped_exp_id = o100592.exp_id)) and o100577.ba_id = paramsq~sq~uq~ sq~sq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~Fsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~JxtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~>sq~sq~uq~tHIERARCHY_NAMEt157q~Eq~Fq~Gt1q~Fq~ItNAtNt ##########t dd-MMM-yyyyq~q~OtHierarchy NametDEFAULTtYpppxsq~uq~ ppppppppppxq~>sq~sq~uq~t CREATED_BYt50q~Eq~Fq~Gt1q~Fq~ItNAtNt ##########t dd-MMM-yyyyq~q~Ot Created BytDEFAULTtYpppxsq~uq~ ppppppppppxq~>sq~sq~uq~tHIERARCHY_LEVELt60q~Eq~Fq~Gt1q~Fq~ItNAtNt ##########t dd-MMM-yyyyq~q~OtHierarchy LeveltDEFAULTtYpppxsq~uq~ ppppppppppxq~>sq~sq~uq~tHIERARCHY_DETAILSt386q~Eq~Fq~Gt1q~Fq~ItNAtNt ##########t dd-MMM-yyyyq~q~OtHierarchy DetailstDEFAULTtYpppxsq~uq~ ppppppppppxq~>pppppxsq~6pqsq~8 sq~$uq~(t Hierarchiesq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq90q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~1tDEFAULTtYppppxt qSELECT o100631.i102167 hierarchy_name, o100631.i102174 created_by, o100631.i102376 hierarchy_level, o100631.i102312 hierarchy_details FROM (SELECT o100577.ba_name AS i101816, o100607.obj_id AS i102327 FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_ba_obj_links o100582 WHERE(o100577.ba_id = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) and o100577.ba_id = param) o100627, (SELECT o100607.obj_id AS i102116, o100592.exp_id AS i102222 FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100607.obj_id = o100592.it_obj_id)) o100630, (SELECT o100603.hil_exp_id AS i102139, (decode(SUBSTR(o100600.hi_name, 1, 19), 'AUTO_GENERATED_NAME', (G_PARAM.G_PARAM_get_foldername((decode(o100600.ibh_dbh_id, NULL, to_number(NULL), G_PARAM.G_PARAM_get_hier_expid(o100600.hi_name))))) || '.' ||(G_PARAM.G_PARAM_get_autogen_item_name((decode(o100600.ibh_dbh_id, NULL, to_number(NULL), G_PARAM.G_PARAM_get_hier_expid(o100600.hi_name))))) || ' : ' ||(decode(o100600.ibh_dbh_id, NULL, NULL, G_PARAM.G_PARAM_get_datehier_tmplt_name(o100600.ibh_dbh_id))), o100600.hi_name)) AS i102167, decode((o100600.hi_sys_generated), 1, 'System', 'User') AS i102174, lpad('^------', 12 *((G_PARAM.G_PARAM_get_hierlvl((o100600.hi_id), (o100601.hn_id))) -1)) ||(decode(SUBSTR((o100601.hn_name), 1, 19), 'AUTO_GENERATED_NAME', ((G_PARAM.G_PARAM_get_foldername(G_PARAM.G_PARAM_get_hiernode_expid(o100601.hn_id))) || '.' ||(G_PARAM.G_PARAM_get_autogen_item_name(G_PARAM.G_PARAM_get_hiernode_expid(o100601.hn_id)))), (o100601.hn_name))) AS i102312, G_PARAM.G_PARAM_get_hierord((o100600.hi_id), (o100603.hil_hn_id)) AS i102376 FROM G_PARAM.G_PARAM_hierarchies o100600, G_PARAM.G_PARAM_hi_nodes o100601, G_PARAM.G_PARAM_ig_exp_links o100603 WHERE(o100600.hi_id = o100601.hn_hi_id) AND(o100601.hn_id = o100603.hil_hn_id)) o100631 WHERE((o100627.i102327 = o100630.i102116) AND(o100630.i102222 = o100631.i102139)) ORDER BY o100631.i102167 ASC, o100631.i102376 ASC sq~sq~uq~ sq~sq~uq~tITEM_CLASS_NAMEt186sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtItem Class NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tPRIMARY_FOLDERt199q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tPrimary FoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tUSED_BYt231q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tUsed BytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tALTERNATE_SORTt176q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tAlternate SorttDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppxsq~6"sq~8sq~$uq~(t Item Classesq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq92q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etctYq~1tDEFAULTtYppppxt SELECT o100632.i102368 item_class_name, o100632.i102366 || ' . ' || o100632.i102064 primary_folder, o100632.i102364 || ' . ' || o100632.i101789 used_by, nvl(o100632.i102356 || '.' || o100632.i101793, ' ') alternate_sort FROM (SELECT o100577.ba_name AS i101816, o100607.obj_id AS i102327 FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_ba_obj_links o100582 WHERE(o100577.ba_id = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) and o100577.ba_id = param) o100627, (SELECT o100607.obj_id AS i102116, o100592.exp_id AS i102222 FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100607.obj_id = o100592.it_obj_id)) o100630, (SELECT o100634.i101787 AS i101789, o100626.i101781 AS i101793, decode(SUBSTR((o100634.i101949), 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No') AS i101953, o100634.i102044 AS i102046, o100633.i101785 AS i102064, o100626.i102350 AS i102356, o100634.i102360 AS i102364, o100633.i102358 AS i102366, decode(SUBSTR((o100634.i101949), 1, 19), 'AUTO_GENERATED_NAME', (o100633.i102358) || '.' ||(o100633.i101785), (o100634.i101949)) AS i102368 FROM (SELECT o100607.obj_name AS i102350, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101781, o100589.dom_id AS i101907 FROM G_PARAM.G_PARAM_domains o100589, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100592.exp_id = o100589.dom_it_id_rank) AND(o100607.obj_id = o100592.it_obj_id)) o100626, (SELECT o100607.obj_name AS i102358, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101785, o100589.dom_id AS i101909 FROM G_PARAM.G_PARAM_domains o100589, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100592.exp_id = o100589.dom_it_id_lov) AND(o100607.obj_id = o100592.it_obj_id)) o100633, (SELECT o100607.obj_name AS i102360, (G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101787, o100589.dom_name AS i101949, o100592.exp_id AS i102044, o100589.dom_id AS i101911 FROM G_PARAM.G_PARAM_domains o100589, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607 WHERE(o100589.dom_id = o100592.it_dom_id) AND(o100607.obj_id = o100592.it_obj_id)) o100634 WHERE(o100626.i101907(+) = o100634.i101911) AND(o100633.i101909(+) = o100634.i101911)) o100632 WHERE((o100627.i102327 = o100630.i102116) AND(o100630.i102222 = o100632.i102046)) ORDER BY o100632.i102368 ASC, o100632.i101953 ASC, o100632.i102366 || ' . ' || o100632.i102064 ASC, nvl(o100632.i102356 || '.' || o100632.i101793, ' ') ASC, o100632.i102364 || ' . ' || o100632.i101789 ASC sq~sq~uq~ sq~sq~uq~tADMINISTRATION_ALLOWEDt87sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtAdministration AllowedtDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tUSER_ROLE_RESPONSIBILITYt85q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tUser Role ResponsibilitytDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppxsq~6 sq~8sq~$uq~(tSecurityq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~Hq~!q~"q~$t dd-MMM-yyyyt #########tq95q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~1tDEFAULTtYppppxtnSELECT DISTINCT decode(o100572.ap_priv_level, 1, 'Yes', 'No') administration_allowed, decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username)), o100591.eu_username) user_role_responsibility FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100577.ba_id = o100582.bol_ba_id) and o100577.ba_id = param AND(o100591.eu_id(+) = o100572.ap_eu_id) AND(o100577.ba_id = o100572.gba_ba_id)) AND(o100572.gba_ba_id IS NOT NULL) sq~sq~uq~ sq~sq~uq~t TABLE_COLUMNt115sq~pppsq~@@@pppsq~pppt1q~bsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~fxt Table ColumntDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~tSUMMARY_SET_NAMEt142q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~ktSummary Set NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~tOWNERt48q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~ktOwnertDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~t TABLE_NAMEt139q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~kt Table NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~t FOLDER_NAMEt107q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~kt Folder NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~tMAP_TOt75q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~ktMap TotDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~t ITEM_NAMEt93q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~kt Item NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Ysq~sq~uq~q~3t450q~aq~bq~ct1q~bq~etNAtNt ##########t dd-MMM-yyyyq~q~ktInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~Yppxsq~6q sq~8 sq~$uq~(t Summariesq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq98q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~StAuthor,Description etctYq~1tDEFAULTtYppppxt SELECT o100639.i102553 summary_set_name, o100639.i102555 owner, o100639.i102492 table_name, o100639.i102464 table_column, 'Maps To ===>' map_to, o100627.i101816 folder_name, decode(o100595.fun_name, NULL, 'Axis Item', initcap(o100595.fun_name)) aggregation, o100639.i101791 item_name FROM G_PARAM.G_PARAM_functions o100595, (SELECT o100577.ba_name AS i101816, o100607.obj_id AS i102327 FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_ba_obj_links o100582 WHERE(o100577.ba_id = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id) and o100577.ba_id = param) o100627, (SELECT(G_PARAM.G_PARAM_get_autogen_item_name(o100592.exp_id)) AS i101791, o100607.obj_id AS i102348, o100607.obj_name AS i102362, o100620.seu_ext_column AS i102464, o100620.smiu_fun_id AS i102468, o100629.i102488 AS i102492, decode(o100629.i102498, 1, decode(o100629.i102502, 3, 'Yes', 6, 'Yes', 'No'), 'No') AS i102507, o100618_2.sdo_table_name AS i102553, o100618_2.sdo_table_owner AS i102555 FROM G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_sumo_exp_usgs o100620, G_PARAM.G_PARAM_summary_objs o100618, (SELECT o100622.srs_name AS i102488, o100622.srs_online AS i102498, o100622.srs_state AS i102502, o100618_2.sumo_id AS i102534 FROM G_PARAM.G_PARAM_summary_objs o100618_2, G_PARAM.G_PARAM_sum_rfsh_sets o100622 WHERE(o100622.srs_id = o100618_2.sbo_srs_id)) o100629, G_PARAM.G_PARAM_summary_objs o100618_2 WHERE(o100629.i102534(+) = o100618_2.sdo_sbo_id) AND(o100592.exp_id = o100620.siu_exp_id) AND(o100607.obj_id = o100592.it_obj_id) AND(o100618_2.sumo_id = o100618.sumo_id) AND(o100618.sumo_id = o100620.seu_sumo_id)) o100639 WHERE((o100627.i102327 = o100639.i102348) AND(o100639.i102468 = o100595.fun_id(+))) AND(o100639.i102492 IS NOT NULL) ORDER BY o100639.i102555 ASC, o100639.i102553 ASC, o100639.i102362 ASC, decode(o100595.fun_name, NULL, 'Axis Item', initcap(o100595.fun_name)) ASC sq~sq~uq~ sq~sq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tDEPENDENT_FOLDERSt95q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tDependent FolderstDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tTABLE_COMPONENTSt134q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tTable ComponentstDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~6sq~8sq~$uq~(tMore Folder Detailsq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~0q~!q~"q~$t dd-MMM-yyyyt #########tq71q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~StAuthor,Description etctYq~1tDEFAULTtYppppxtzSELECT REPLACE(G_PARAM.G_PARAM_get_object_name(G_PARAM.G_PARAM_get_complex_folder(o100607.obj_id), 'F'), ', ', CHR(10)) dependent_folders, REPLACE(G_PARAM.G_PARAM_get_object_name(G_PARAM.G_PARAM_get_simple_folder(o100607.obj_id), 'F'), ', ', CHR(10)) folder_components, G_PARAM.G_PARAM_get_analyzed(o100607.obj_id, 'T') Table_components, G_PARAM.G_PARAM_get_analyzed(o100607.obj_id, 'D') Analyzed FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) AND(o100607.obj_id = o100582.bol_obj_id)) and o100607.obj_id = paramsq~sq~ uq~sq~sq~uq~tInfoCaptor Messaget450sq~pppsq~pppsq~pppt1q~Isq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~t ITEM_NAMEt111q~Hq~Iq~Jt1q~Iq~LtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Item Name tDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~tEXP_ELEMENT_STATEt75sq~pppq~Iq~t1q~Iq~LtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~tEXP_IDt41q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(tExp IdtDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~t IT_EXT_COLUMNt105q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(t It Ext ColumntDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~t FOLDER_NAMEt100q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(t Folder NametDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~tBA_NAMEt101q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxpq~@sq~sq~uq~tITEMt116q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxpq~@sq~sq~uq~tITEM_DEPENDENCYt189q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~tITEM_KEYt105q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(tItem KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~@sq~sq~uq~tITEM_DEPENDS_ONt168q~oq~Iq~t1q~Iq~tNAtNt ##########t dd-MMM-yyyyq~q~(tItem Depends OntDEFAULTtYpppxsq~uq~ ppppppppppxq~@pppppppppxsq~6}sq~8AFsq~$uq~(t Folder Itemsq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq35q~q~(tNtappst No_PatterntQLETsq~pppq~ItXXDBNAMEq~tAuthor,Description etctYq~1tDEFAULTtYppppxtJselect i.exp_name item_name, i.exp_description item_description, G_PARAM.G_PARAM_get_item((i.exp_id)) Item_depends_on , i.it_ext_column, i.exp_developer_key item_key, i.exp_id item_id from G_PARAM.G_PARAM_expressions i , G_PARAM.G_PARAM_objs f , G_PARAM.G_PARAM_ba_obj_links l , G_PARAM.G_PARAM_bas b where f.obj_id= i.it_obj_id and f.obj_id= l.bol_obj_id and b.ba_id= l.bol_ba_id and f.obj_id = param order by b.ba_name,f.obj_name,i.exp_namesq~sq~uq~ sq~sq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tFOLDERt136q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tFoldertDEFAULTtYpppxsq~uq~ srInfoPurple.DrillSettings ඳcL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ t FOLDER_IDpppppppppxtGet Folder Detailsq~3sq~.sq~uq~ t FOLDER_IDpppppppppxtGet Folder Itemsq~sq~.sq~uq~ t FOLDER_IDpppppppppxtGet Folder Joinstq37pppppppxq~sq~sq~uq~t FOLDER_HIDDENt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder HiddentDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t FOLDER_TYPEt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder TypetDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppxsq~6}sq~8;sq~$uq~(tFoldersq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~fq~!q~"q~$t dd-MMM-yyyyt #########tq67q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~t1000tDEFAULTtYppppxtSELECT o100607.obj_name Folder, decode(o100607.obj_hidden, 1, 'Hidden', 'Visible') folder_hidden, decode(o100607.obj_type, 'COBJ', 'Complex', 'SOBJ', 'Simple', 'CUO', 'Custom', 'Unknown') folder_type, o100607.obj_description description, o100607.obj_developer_key Folder_Key, o100607.obj_updated_date last_updated, o100607.obj_id folder_id FROM G_PARAM.G_PARAM_bas o100577, G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607 WHERE((o100577.ba_id(+) = o100582.bol_ba_id) and o100577.ba_id = param AND(o100607.obj_id = o100582.bol_obj_id)) ORDER BY o100607.obj_name ASC sq~sq~uq~ sq~sq~uq~tKEY_DESCRIPTIONt711sq~pppsq~pppsq~pppt1q~sq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtKey Description tDEFAULTtYpppxsq~uq~ ppppppppppxq~wsq~sq~uq~t JOIN_NAMEt298q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Join NametDEFAULTtYpppxsq~uq~ ppppppppppxq~wsq~sq~uq~tJOIN_CONDITIONt282q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(tJoin ConditiontDEFAULTtYpppxsq~uq~ ppppppppppxq~wsq~sq~uq~t JOIN_DETAILSt137q~oq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Join DetailstDEFAULTtYpppxsq~uq~ ppppppppppxq~wppppppxsq~6sq~8Gsq~$uq~(t Folder Joinsq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########q~>q~q~(tNtappst No_PatterntQLETsq~pppq~tXXDBNAMEq~KtAuthor,Description etctYq~1tDEFAULTtYppppxtSELECT distinct decode(decode(SUBSTR(o100605.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No'), 'Yes', G_PARAM.G_PARAM_get_join(o100592.exp_id), o100605.key_name) join_name , G_PARAM.G_PARAM_get_join(o100592.exp_id, 'N') join_condition , decode(o100605.fk_mandatory, 1, 'Always exist in master folder', 'Might not exist in master folder') join_details , nvl(decode(o100605.fk_mstr_no_detail, 1, 'Outer join on detail' || CHR(10), NULL) || decode(o100605.fk_dtl_no_master, 1, 'Outer join on master' || CHR(10), NULL) || decode(o100605.fk_one_to_one, 1, 'One to one join', NULL), 'None') optional_join_configuration , decode(SUBSTR(o100605.key_name, 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No') Auto FROM G_PARAM.G_PARAM_ba_obj_links o100582, G_PARAM.G_PARAM_objs o100607, G_PARAM.G_PARAM_expressions o100592, G_PARAM.G_PARAM_key_cons o100605 WHERE((o100607.obj_id = o100582.bol_obj_id) AND(o100605.key_id = o100592.jp_key_id) AND(o100607.obj_id = o100605.fk_obj_id_remote)) and o100607.obj_id = param sq~sq~uq~ sq~sq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t WORKBOOK_KEYt75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tFOLDERt84q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tFoldertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tDEPENDENCY_NAMEt243q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tDependency NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t FOLDER_KEYt121q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Folder KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tDEPENDENCY_KEYt183q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tDependency KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppxsq~6.sq~8{sq~$uq~(tWorkbook Dependenciesq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~?q~!q~"q~$t dd-MMM-yyyyt #########tq107q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~1tDEFAULTtYppppxt"SELECT -- o100588.doc_name workbook_name, -- o100588.doc_developer_key workbook_key, decode(o100590.ex_to_type, 'ITE', 'Item', 'JOI', 'Join', 'FIL', 'Condition', o100590.ex_to_type) dependency_type, o100590.ex_to_par_name folder, (decode(SUBSTR(o100590.ex_to_name, 1, 19), 'AUTO_GENERATED_NAME', (decode(o100590.ex_to_type, 'JOI', (decode((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_join((decode(o100590.ex_to_type, 'JOI', G_PARAM.G_PARAM_get_join_expid(o100590.ex_to_id, o100590.ex_to_devkey), to_number(NULL)))))), 'ITE', (decode((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL))), NULL, NULL, G_PARAM.G_PARAM_get_autogen_item_name((decode(o100590.ex_to_type, 'ITE', o100590.ex_to_id, to_number(NULL)))))), 'FIL', (decode((decode(o100590.ex_to_type, 'FIL', o100590.ex_to_id, to_number(NULL))), NULL, NULL, o100590.ex_to_name)), NULL)), o100590.ex_to_name)) Dependency_name , o100590.ex_to_par_devkey folder_key, o100590.ex_to_devkey Dependency_key FROM G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_elem_xrefs o100590 WHERE(((to_number(o100590.ex_from_id)) = o100588.doc_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and o100588.doc_id = param ORDER BY o100588.doc_developer_key ASC, o100588.doc_name ASC, decode(o100590.ex_to_type, 'ITE', 'Item', 'JOI', 'Join', 'FIL', 'Condition', o100590.ex_to_type) DESC, o100590.ex_to_par_name ASC, o100590.ex_to_par_devkey ASCsq~sq~ uq~ sq~sq~uq~q~t450sq~pppsq~@@@pppsq~pppt1q~Xsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~\xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~t WORKBOOK_NAMEt180q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Workbook NametDEFAULTtYpppxsq~uq~ sq~.sq~uq~ tDOC_IDpppppppppxtGet Workbook Dependenciesq~Bsq~.sq~uq~ tDOC_IDpppppppppxtGet sharing Detailstq127ppppppppxq~Psq~sq~uq~t CREATED_BYt94q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Created BytDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~t WORKBOOK_SIZEt51q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~t CREATION_DATEt67q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Creation DatetDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~t SHARED_WITHt131q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Shared WithtDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~tsize[KB]t26q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~t size [KB]t25q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~at Size [kb]tDEFAULTtYpppxsq~uq~ ppppppppppxq~Psq~sq~uq~tDOC_DEVELOPER_KEYt75q~Wq~Xq~Yt1q~Xq~[tNAtNt ##########t dd-MMM-yyyyq~q~atDoc Developer KeytDEFAULTtYpppxsq~uq~ ppppppppppxq~Ppxsq~64sq~8sq~$uq~(t Workbook Infoq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq102q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etctYt30tDEFAULTtYppppxt?SELECT distinct o100588.doc_name workbook_name, decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) created_by, o100588.doc_length / 1024 "size [KB]", o100588.doc_created_date creation_date, o100588.doc_developer_key, o100588.doc_id FROM G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100588.doc_id = o100572.gd_doc_id(+)) AND(o100591.eu_id(+) = o100572.ap_eu_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(o100588.doc_created_by), o100588.doc_created_by) like 'G_PARAM' /*'ID1'*/ ORDER BY o100588.doc_name ASC, o100588.doc_created_date ASCsq~sq~uq~ sq~sq~uq~t SHARED_WITHt322sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Shared WithtDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget450q~ q~ q~t1q~ q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~6@7sq~8Nsq~$uq~(tWorkbook Sharing Infoq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~4q~!q~"q~$t dd-MMM-yyyyt #########q~q~q~(q~Dtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctYq~1tDEFAULTtYppppxtSELECT '>> '|| decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username, 'R'), decode(o100591.eu_username, NULL, 'Document Not Shared', G_PARAM.G_PARAM_get_apps_userresp(o100591.eu_username))), nvl(o100591.eu_username, 'Document Not Shared')) shared_with, o100572.ap_created_date shared_with_date FROM G_PARAM.G_PARAM_access_privs o100572, G_PARAM.G_PARAM_documents o100588, G_PARAM.G_PARAM_eul_users o100591 WHERE((o100588.doc_id = o100572.gd_doc_id(+)) AND(o100591.eu_id(+) = o100572.ap_eu_id)) AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') AND(o100588.doc_content_type = 'application/vnd.oracle-disco.wb') and o100588.doc_id = param ORDER BY o100588.doc_name ASC, o100588.doc_created_date ASCsq~sq~uq~ sq~sq~uq~q~Ft450sq~pppsq~pppsq~pppt1q~Ksq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~t Business Areat166q~Jq~Kq~Lt1q~Kq~NtNAtNt ##########t dd-MMM-yyyyq~sq~A@ ptArialxtBusiness Area tDEFAULTtYpppxsq~uq~ sq~.sq~uq~ tBA_IDpppppppppxtGet Folder Detailsq~isq~.sq~uq~ q~opppppppppxt Get Filtersq~0sq~.sq~uq~ q~opppppppppxtGet Hierarchiesq~sq~.sq~uq~ q~opppppppppxtGet Item Classesq~sq~.sq~uq~ tBA_IDpppppppppxtGet Security Detailsq~Ksq~.sq~uq~ q~pppppppppxt Get Summariesq~ppppxq~Csq~sq~uq~tKeyt145q~oq~Kq~t1q~Kq~tNAtNt ##########t dd-MMM-yyyyq~q~(tKeytDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~tNumber of Times Modifiedt47q~oq~Kq~t1q~Kq~tNAtNt ##########t dd-MMM-yyyyq~q~(tNumber Of Times ModifiedtDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~tCreatort87q~oq~Kq~t1q~Kq~tNAtNt ##########t dd-MMM-yyyyq~q~(tCreatortDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~t Creation Datet66q~,q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Creation DatetDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~t Updated By t115q~,q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(t Updated BytDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~tLast Update Datet74q~,q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~(tLast Update DatetDEFAULTtYpppxsq~uq~ ppppppppppxq~Cppxsq~6}sq~8sq~$uq~(tBusiness Areasq~>t100tManualt1440t 1-JAN-1990tYq~q~q~q~q~q~q~q~q~!q~"q~$t dd-MMM-yyyyt #########tq32q~q~(q~Dtappst No_PatterntQLETsq~pppq~KtXXDBNAMEq~tAuthor,Description etctYt20tDEFAULTtYppppxtselect ba_name "Business Area" , ba_developer_key "Key" ,ba_created_by "Creator" , decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(ba_created_by), ba_created_by) created_by ,ba_created_date "Creation Date" , decode(G_PARAM.G_PARAM_get_isitapps_eul, 1, G_PARAM.G_PARAM_get_apps_userresp(ba_updated_by), ba_updated_by) Updated_By ,ba_updated_date "Last Update Date" ,notm "Number of Times Modified" ,ba_id from G_PARAM.G_PARAM_bas where ba_created_by like 'G_PARAM' /*'ID1'*/ and lower(ba_name) like lower('G_PARAM') sq~sq~uq~ sq~sq~uq~t REPORT_NAMEt132sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Report NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t WORK_SHEETt145q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~ t Work SheettDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~6sq~8 sq~$uq~(tWorkbook Summaryq~>t100tManualt1440t 1-JAN-1990tYq~q~q~t1q~q~t15q~(q~!sq~A@ pq~xq~$t dd-MMM-yyyyt #########tq159q~q~ tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~(t50tDEFAULTtYppppxtSELECT DISTINCT QS_DOC_NAME Report_Name, QS_DOC_DETAILS Work_Sheet, (G_PARAM.G_PARAM_GET_OBJECT_NAME(G_PARAM.G_PARAM_GET_FORJ_ITEMID(QS_ID),'I')) Table_View_Used, (G_PARAM.G_PARAM_GET_OBJECT_NAME(SUBSTR(QS_OBJECT_USE_KEY,1, DECODE(INSTR(QS_OBJECT_USE_KEY,'S',1,1),0, LENGTH(QS_OBJECT_USE_KEY), INSTR(QS_OBJECT_USE_KEY,'S',1,1)-2)),'F')) Items_Used, (G_PARAM.G_PARAM_GET_OBJECT_NAME(G_PARAM.G_PARAM_GET_ITEM_NAME(QS_ID),'I')) Table_Join_Used, (G_PARAM.G_PARAM_GET_OBJECT_NAME((G_PARAM.G_PARAM_GET_FORJ_ITEMID(QS_ID,'JOIN')),'J')) Joins, QS_OBJECT_USE_KEY OjbKey FROM G_PARAM.G_PARAM_QPP_STATS ORDER BY QS_DOC_NAME ASC sq~sq~uq~ sq~sq~uq~t#RIGHTCLICKONEACHPARAMETERANDREFRESHt199sq~pppsq~@@@pppsq~pppt1q~Esq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~Ixt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~t100tManualt1440t 1-JAN-1990tYsq~pppq~Dq~Ft4q~iq~Et20q~~q~!sq~A@ pq~jxq~$t dd-MMM-yyyyt #########tq182sq~pppq~oq~~tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNt1tDEFAULTtYppppxtselect * from ( select 1 seq, 'Right click on each parameter and Refresh' "Follow the steps" from dual union select 2 ,'For e.g. Right click on EUL Owner and refresh' from dual union select 3, 'Similarly refresh all the remaining parameters' from dual union select 4, 'Then refresh each portlet starting with Business Area and verify the drills' from dual union select 5,'OR Right click on the below link and launch the short video tutorial' from dual union select 6,'http://www.infocaptor.com/demo/disco_report_demo.htm' from dual union select 7, 'Once everything is set, optionally delete this Qlet (First Timer Instructions) by clicking on the scissor icon' from dual ) order by seq ascpppppppppppppppx