Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search

/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 43.ddi / ORDERS.SQL < prev next >

Wrap

Text File | 1990-06-07 | 37.4 KB | 1,943 lines

Rem Rem Export of application ORDERS (generated on fri dec 15 13:35 1989) Rem Set termout off Set verify off Set heading off Set echo off Set scan off Column x newline Spool orders.LIS Select decode(count(*),0,'prompt Importing Application ORDERS', 'prompt Application ORDERS already exists !'), decode(count(*),0,'', 'exit') x From menu_b_appl Where application_name = 'ORDERS' ; Spool off Set termout on @orders.LIS Set termout off Set echo on Spool orders.LIS Rem Rem export of table MENU_B_APPL ( Application ORDERS) Rem Insert into MENU_B_APPL ( APPLICATION_NAME, SHORT_NAME, FILE_NAME, CREATION_DATE, CREATOR, VERSION_RELEASE_NR, LAST_RELEASE_DATE, MENU_DIRECTORY, IDENTIFICATION ) values ( 'ORDERS', 'Orders', 'orders', '01-SEP-89', 'SCOTT', ' 1', '', '', 'Sales Order Application' ) ; Commit ; Rem Rem export of table MENU_B_APPL_GRP ( Application ORDERS) Rem Insert into MENU_B_APPL_GRP ( APPLICATION_NAME, GROUP_NAME ) values ( 'ORDERS', 'CLERKS' ) ; Insert into MENU_B_APPL_GRP ( APPLICATION_NAME, GROUP_NAME ) values ( 'ORDERS', 'MANAGERS' ) ; Commit ; Rem Rem export of table MENU_B_INFO ( Application ORDERS) Rem Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'BGM', 'ORDERS', 'Background Menu', 'Sales Order Application', 'Summit Sporting Goods', ' 1' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'ORDERS', 'ORDERS', 'Sales Order Application', 'A Sample Menu Application', 'Summit Sporting Goods', ' 2' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'ORDREP', 'ORDERS', 'Order Report Menu', 'Sales Order Application', 'Summit Sporting Goods', ' 3' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'PRODREP', 'ORDERS', 'Product Report Menu', 'Sales Order Application', 'Summit Sporting Goods', ' 4' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'REPORTS', 'ORDERS', 'Report Menu', 'Sales Order Application', 'Summit Sporting Goods', ' 5' ) ; Insert into MENU_B_INFO ( MENU_NAME, APPLICATION_NAME, TITLE, SUB_TITLE, BOTTOM_TITLE, OBJECT_TEXT_ID ) values ( 'UTILITIES', 'ORDERS', 'Utilities Menu', 'Sales Order Application', 'Summit Sporting Goods', ' 6' ) ; Commit ; Rem Rem export of table MENU_B_OPTION ( Application ORDERS) Rem Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'BGM', 'ORDERS', ' 1', 'Dated orders', 'Y', 'Report on sales orders in a range of dates', ' 11', ' 5', 'sqlplus -s ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw @datords ' || chr(ascii('&')) || 'sd ' || chr(ascii('&')) || 'ed' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'BGM', 'ORDERS', ' 2', 'Orders', 'Y', 'Update sales orders and customer data', ' 12', ' 4', 'runform orders ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ORDERS', 'ORDERS', ' 1', 'Reports', 'Y', 'Report on sales orders and customers', ' 13', ' 1', 'reports' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ORDERS', 'ORDERS', ' 2', 'Utilities', 'Y', 'Display the Utilities menu', ' 14', ' 1', 'utilities' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ORDERS', 'ORDERS', ' 3', 'Orders', 'Y', 'Update sales orders and customer data', ' 15', ' 4', 'runform orders ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ORDERS', 'ORDERS', ' 4', 'Exit', 'Y', 'Exit from the Orders menu application', ' 16', ' 7', 'exit_menu;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ORDREP', 'ORDERS', ' 1', 'All orders', 'Y', 'Report on all sales orders', ' 17', ' 5', 'sqlplus -s ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw @allords' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'ORDREP', 'ORDERS', ' 2', 'Dated orders', 'Y', 'Report on sales orders in a range of dates', ' 18', ' 5', 'sqlplus -s ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw @datords ' || chr(ascii('&')) || 'sd ' || chr(ascii('&')) || 'ed' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'PRODREP', 'ORDERS', ' 1', 'All customers', 'Y', 'Report on products ordered by all customers', ' 19', ' 5', 'sqlplus -s ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw @allprod' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'PRODREP', 'ORDERS', ' 2', 'One customer', 'Y', 'Report on products ordered by a specified customer', ' 20', ' 5', 'sqlplus -s ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw @cusprod ' || chr(ascii('&')) || 'ci' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'REPORTS', 'ORDERS', ' 1', 'Orders', 'Y', 'Report on sales orders', ' 21', ' 1', 'ordrep' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'REPORTS', 'ORDERS', ' 2', 'Products', 'Y', 'Report on products ordered', ' 22', ' 1', 'prodrep' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'REPORTS', 'ORDERS', ' 3', 'Customers', 'Y', 'Report on sales orders and credit limits for all customers', ' 23', ' 5', 'sqlplus -s ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw @ccredit' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'UTILITIES', 'ORDERS', ' 1', 'Directory', 'N', 'List directory information, optionally using a search string', ' 24', ' 3', 'dir ' || chr(ascii('&')) || 'st' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'UTILITIES', 'ORDERS', ' 2', 'OS commands', 'Y', 'Execute operating system commands', ' 25', ' 6', 'oscmd;' ) ; Insert into MENU_B_OPTION ( MENU_NAME, APPLICATION_NAME, OPTION_NUMBER, SHORT_NAME, DISPLAYED, OPTION_TEXT, OBJECT_TEXT_ID, COMMAND_TYPE, COMMAND_LINE ) values ( 'UTILITIES', 'ORDERS', ' 3', 'SQL*Plus', 'N', 'Run SQL*Plus ("exit" returns to SQL*Menu)', ' 26', ' 5', 'sqlplus ' || chr(ascii('&')) || 'un/' || chr(ascii('&')) || 'pw' ) ; Commit ; Rem Rem export of table MENU_B_PARAM ( Application ORDERS) Rem Insert into MENU_B_PARAM ( SUBSTITUTION_STRING, APPLICATION_NAME, PAR_SIZE, PAR_DEF, ECHO, MUST_FILL, RESPONSE_REQUIRED, UPPER_CASE, OBJECT_TEXT_ID, PROMPT ) values ( 'ci', 'ORDERS', ' 6', '100', 'Y', 'N', 'Y', 'N', ' 7', 'Customer ID:' ) ; Insert into MENU_B_PARAM ( SUBSTITUTION_STRING, APPLICATION_NAME, PAR_SIZE, PAR_DEF, ECHO, MUST_FILL, RESPONSE_REQUIRED, UPPER_CASE, OBJECT_TEXT_ID, PROMPT ) values ( 'ed', 'ORDERS', ' 9', '31-DEC-99', 'Y', 'Y', 'N', 'N', ' 8', 'Ending Date (DD-MON-YY):' ) ; Insert into MENU_B_PARAM ( SUBSTITUTION_STRING, APPLICATION_NAME, PAR_SIZE, PAR_DEF, ECHO, MUST_FILL, RESPONSE_REQUIRED, UPPER_CASE, OBJECT_TEXT_ID, PROMPT ) values ( 'sd', 'ORDERS', ' 9', '01-JAN-85', 'Y', 'Y', 'N', 'N', ' 9', 'Starting Date (DD-MON-YY):' ) ; Insert into MENU_B_PARAM ( SUBSTITUTION_STRING, APPLICATION_NAME, PAR_SIZE, PAR_DEF, ECHO, MUST_FILL, RESPONSE_REQUIRED, UPPER_CASE, OBJECT_TEXT_ID, PROMPT ) values ( 'st', 'ORDERS', ' 40', '*.*', 'Y', 'N', 'N', 'N', ' 10', 'Search String:' ) ; Commit ; Rem Rem export of table MENU_B_PARM_XREF ( Application ORDERS) Rem Commit ; Rem Rem export of table MENU_B_PRIV ( Application ORDERS) Rem Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 1', 'MNU', 'ORDERS', 'BGM', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 2', 'MNU', 'ORDERS', 'BGM', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 3', 'MNU', 'ORDERS', 'ORDERS', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 4', 'MNU', 'ORDERS', 'ORDERS', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 5', 'MNU', 'ORDERS', 'ORDERS', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 6', 'MNU', 'ORDERS', 'ORDERS', ' 4' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 7', 'MNU', 'ORDERS', 'ORDREP', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 8', 'MNU', 'ORDERS', 'ORDREP', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 9', 'MNU', 'ORDERS', 'PRODREP', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 10', 'MNU', 'ORDERS', 'PRODREP', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 11', 'MNU', 'ORDERS', 'REPORTS', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 12', 'MNU', 'ORDERS', 'REPORTS', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 13', 'MNU', 'ORDERS', 'REPORTS', ' 3' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 14', 'MNU', 'ORDERS', 'UTILITIES', ' 1' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 15', 'MNU', 'ORDERS', 'UTILITIES', ' 2' ) ; Insert into MENU_B_PRIV ( PRIVILEGE_ID, PRIVILEGE_TYPE, APPLICATION_NAME, MENU_NAME, OPTION_NUMBER ) values ( ' 16', 'MNU', 'ORDERS', 'UTILITIES', ' 3' ) ; Commit ; Rem Rem export of table MENU_B_REF ( Application ORDERS) Rem Commit ; Rem Rem export of table MENU_B_PROCEDURE ( Application ORDERS) Rem Commit ; Rem Rem export of table MENU_B_OBJ_TEXT ( Application ORDERS) Rem Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 1', ' 1', 'The BGM menu is the background menu. It contains commands that are used ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 1', ' 2', 'as accelerators for other menu choices.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 1', 'The ORDERS menu is the main menu for the ORDERS menu application, which' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 2', ' provides order-entry and order-reporting operations for the Summit Sporting' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 3', ' Goods store. The ORDERS menu calls two submenus (REPORTS and UTILITIES)' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 4', ' and one form (ORDERS). ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 5', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 6', 'The ORDERS menu application has two roles: CLERKS and MANAGERS. CLERKS' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 7', ' cannot run reports summarizing the customer credit limits and sales, or the' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 8', ' products ordered by all customers. CLERKS also cannot use the Utilities' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 9', ' menu items that execute operator-defined operating system commands (OS' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 2', ' 10', ' commands) or SQL*Plus commands.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 3', ' 1', 'This menu contains items to run predefined sales reports for a range of' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 3', ' 2', ' order dates or for all order dates.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 4', ' 1', 'This menu contains items to run predefined sales reports of the products' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 4', ' 2', ' ordered by one customer or by all customers.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 5', ' 1', 'This menu contains items to run several predefined sales reports.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 6', ' 1', 'This menu allows the application user to access the operating system.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 7', ' 1', 'Enter a customer ID number (CUSTID) for the report.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 8', ' 1', 'Enter an ending date for the report, in the form DD-MON-YY.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 9', ' 1', 'Enter a starting date for the report, in the form DD-MON-YY.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 10', ' 1', 'Enter a search string for the directory listing.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 11', ' 1', 'This item runs a report that lists information about orders placed during a' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 11', ' 2', ' specified time range. Before running the report, SQL*Menu prompts you for' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 11', ' 3', ' starting and ending dates.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 12', ' 1', 'This item runs the ORDERS form, which lets you insert, update, or delete' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 12', ' 2', ' information about orders and customers. ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 12', ' 3', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 12', ' 4', 'Before you can run the ORDERS form from the Orders Application, you must be' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 12', ' 5', ' granted access to the form by your database administrator (DBA).' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 13', ' 1', 'This item goes to the Reports menu, which lets you run reports about sales' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 13', ' 2', ' orders and customer information.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 14', ' 1', 'This item goes to the Utilities menu, which lets you execute an operating' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 14', ' 2', ' system command or list directory information.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 15', ' 1', 'This item runs the ORDERS form, which lets you insert, update, or delete' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 15', ' 2', ' information about orders and customers. ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 15', ' 3', ' ' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 15', ' 4', 'Before you can run the ORDERS form from the Orders Application, you must be' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 15', ' 5', ' granted access to the form by your database administrator (DBA).' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 16', ' 1', 'This item exits SQL*Menu (Run Menu) and returns to the operating system or' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 16', ' 2', ' to the program that called SQL*Menu (Run Menu).' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 17', ' 1', 'This item runs a report that lists all orders with their dates, items, and' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 17', ' 2', ' total values.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 18', ' 1', 'This item runs a report that lists information about orders placed during a' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 18', ' 2', ' specified time range. Before running the report, SQL*Menu prompts you for' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 18', ' 3', ' starting and ending dates.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 19', ' 1', 'This item runs a report that lists the products ordered by all customers.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 20', ' 1', 'This item runs a report that lists the products ordered by a customer.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 20', ' 2', ' Before running the report, SQL*Menu prompts you for a customer''s ID number.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 21', ' 1', 'This item goes to the Order Report menu, which lets you run predefined sales' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 21', ' 2', ' reports for a range of order dates or for all order dates.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 22', ' 1', 'This item goes to the Product Report menu, which lets you run predefined' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 22', ' 2', ' sales reports of the products ordered by one customer or by all customers.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 23', ' 1', 'This item runs a report that lists sales orders and credit limits for all' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 23', ' 2', ' customers.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 24', ' 1', 'This item executes an operating system command to list the contents of the' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 24', ' 2', ' default directory. You can specify a search string using the operating' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 24', ' 3', ' system''s wildcard characters.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 25', ' 1', 'This item lets you enter one or more operating system commands. To return' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 25', ' 2', ' to SQL*Menu, enter a blank line at the OS> prompt.' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 26', ' 1', 'This item lets you execute SQL*Plus commands. To return to SQL*Menu, enter' ) ; Insert into MENU_B_OBJ_TEXT ( APPLICATION_NAME, OBJECT_TEXT_ID, OBJECT_TEXT_ORDER, OBJECT_TEXT ) values ( 'ORDERS', ' 26', ' 2', ' "exit" at the SQL*Plus prompt.' ) ; Commit ; Rem Rem export of table MENU_B_GRP_PRIV ( Application ORDERS) Rem Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 1' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 2' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 3' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 4' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 5' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 6' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 7' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 8' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 10' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 11' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 12' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'CLERKS', ' 14' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 1' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 2' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 3' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 4' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 5' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 6' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 7' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 8' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 9' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 10' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 11' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 12' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 13' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 14' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 15' ) ; Insert into MENU_B_GRP_PRIV ( APPLICATION_NAME, GROUP_NAME, PRIVILEGE_ID ) values ( 'ORDERS', 'MANAGERS', ' 16' ) ; Commit ; Set scan on Set verify on Set heading on Spool off Set termout on exit;