App 101 - Sample Application Application Definition Shared Components Authorization Scheme Edit Products You are not authorized to edit Product Information. You are not authorized to edit Product Information. Edit Products Authorization Scheme Verify Order Ownership You are not authorized to view this order!<br />Click <a href="f?p=&APP_ID.:4:&SESSION.">here</a> to continue You are not authorized to view this order!<br />Click <a href="f?p=&APP_ID.:4:&SESSION.">here</a> to continue Verify Order Ownership Authorization Scheme Admin Users You need to be an Admin User in order to view this page. You need to be an Admin User in order to view this page. Admin Users Authorization Scheme Tab Home Home Home Home Tab Customers Customers Customers Customers Tab Products Products Products Products Tab Orders Orders Orders Orders Tab Reports Reports Reports Reports Tab Administration Administration Administration Administration Tab Shortcut DELETE_CONFIRM_MSG Would you like to perform this delete action? Would you like to perform this delete action? DELETE_CONFIRM_MSG Shortcut OK_TO_GET_NEXT_PREV_PK_VALUE Are you sure you want to leave this page without saving? Are you sure you want to leave this page without saving? OK_TO_GET_NEXT_PREV_PK_VALUE Shortcut List of Values CATEGORIES LOV Entry Mens Mens Mens Mens List of Values Entries Womens Womens Womens Womens List of Values Entries Accessories Accessories Accessories Accessories List of Values Entries Y OR N LOV Entry Yes Yes Yes Yes List of Values Entries No No No No List of Values Entries List Administration List Entry Manage Users Manage Users Manage Users Manage Users List Entries Charts Charts Charts Charts List Entries Order Wizard List Entry Identify Customer Identify Customer Identify Customer Identify Customer List Entries Select Items Select Items Select Items Select Items List Entries Order Summary Order Summary Order Summary Order Summary List Entries Create Customer Create Customer Create Customer Create Customer List Entries Report Tabs List Entry Sales by Category / Month Sales by Category / Month Sales by Category / Month Sales by Category / Month List Entries Sales by Category and Product Sales by Category and Product Sales by Category and Product Sales by Category and Product List Entries Customer Orders Customer Orders Customer Orders Customer Orders List Entries Order Calendar Order Calendar Order Calendar Order Calendar List Entries Customer Map Customer Map Customer Map Customer Map List Entries Product Order Tree Product Order Tree Product Order Tree Product Order Tree List Entries Tasks List Entry Add a New Customer Add a New Customer Add a New Customer Add a New Customer List Entries Add a New Product Add a New Product Add a New Product Add a New Product List Entries Enter a New Order Enter a New Order Enter a New Order Enter a New Order List Entries Breadcrumb Main Menu Breadcrumb Entry Home Home Home Home Breadcrumb Customers Customers Customers Customers Breadcrumb Customer Details Customer Details Customer Details Customer Details Breadcrumb Administration Administration Administration Administration Breadcrumb Products Products Products Products Breadcrumb Product Details Product Details Product Details Product Details Breadcrumb Orders Orders Orders Orders Breadcrumb Order Details Order Details Order Details Order Details Breadcrumb Enter New Order Enter New Order Enter New Order Enter New Order Breadcrumb Enter New Order Enter New Order Enter New Order Enter New Order Breadcrumb Order Summary Order Summary Order Summary Order Summary Breadcrumb Reset Password Reset Password Reset Password Reset Password Breadcrumb Reports Reports Reports Reports Breadcrumb Reports Reports Reports Reports Breadcrumb Reports Reports Reports Reports Breadcrumb Reports Reports Reports Reports Breadcrumb Enter New Order Enter New Order Enter New Order Enter New Order Breadcrumb Reports Reports Reports Reports Breadcrumb Reports Reports Reports Reports Breadcrumb Navigation Bar Entry Logout Logout Logout Logout Navigation Bar Logout Logout Logout Navigation Bar Print Print Print Print Navigation Bar Print Print Print Navigation Bar Feedback Feedback Feedback Feedback Navigation Bar Popup LOV Template Popup LOV </div> </div> Popup LOV PopUp LOV Template </div> </div> Popup LOV PopUp LOV Template <div class="t1PopupHead"> <div class="t1PopupHead"> Popup LOV PopUp LOV Template <div class="t1PopupBody"> <div class="t1PopupBody"> Popup LOV PopUp LOV Template Close Close Popup LOV PopUp LOV Template Search Search Popup LOV PopUp LOV Template Next > Next > Popup LOV PopUp LOV Template Search Dialog Search Dialog Popup LOV PopUp LOV Template < Previous < Previous Popup LOV PopUp LOV Template <br /><div style="padding:2px; font-size:8pt;">Row(s) #FIRST_ROW# - #LAST_ROW#</div> <br /><div style="padding:2px; font-size:8pt;">Row(s) #FIRST_ROW# - #LAST_ROW#</div> Popup LOV PopUp LOV Template Pages 0 - Page Zero Page Definition Page Zero Page Zero 0 - Page Zero Page Definition Page Zero Page Zero 0 - Page Zero Page Definition Regions Menu Region Definition Menu Menu Region Interactive Report Flash Chart Reports Region Definition Reports Reports Region Interactive Report Flash Chart 1 - Sample Application Page Definition Sample Application Sample Application 1 - Sample Application Page Definition Oracle Sample Application Oracle Sample Application 1 - Sample Application Page Definition This is the Home Page of the Sample Application. It is intended to be a sales dashboard of sorts - displaying some metrics which are derived in real-time from the database.<p>The <strong>My Quota</strong> region is a Flash chart type called Dial Chart. It is dynamically rendered based on a SQL Statement each time the page is viewed. <strong>My Top Orders</strong> displays the top five orders for the currently signed in user, based on order total. The <strong>Tasks</strong> region is an example of using a List to provide easy navigation to common tasks. This is the Home Page of the Sample Application. It is intended to be a sales dashboard of sorts - displaying some metrics which are derived in real-time from the database.<p>The <strong>My Quota</strong> region is a Flash chart type called Dial Chart. It is dynamically rendered based on a SQL Statement each time the page is viewed. <strong>My Top Orders</strong> displays the top five orders for the currently signed in user, based on order total. The <strong>Tasks</strong> region is an example of using a List to provide easy navigation to common tasks. 1 - Sample Application Page Definition Regions Sales Quota Region Definition My sales measured against quota My sales measured against quota Region Sales Quota Sales Quota Region Interactive Report Flash Chart Sales Quota Series Series 1 Series 1 Series 1 Series 1 Flash Chart (Anychart5) No sales found for current user. No sales found for current user. Series 1 Flash Chart (Anychart5) Sales Quota Region Definition Admins have no quota Admins have no quota Region Sales Quota Sales Quota Region Interactive Report Flash Chart Top Customers Region Definition Top Customers Top Customers Region no data found no data found Region Interactive Report Flash Chart Report Column CUSTOMER_NAME #CUSTOMER_NAME# #CUSTOMER_NAME# CUSTOMER_NAME Classic Report Column Button VIEW_CUSTOMERS View Customers View Customers VIEW_CUSTOMERS Page Button Top Products Region Definition Top Products Top Products Region no data found no data found Region Interactive Report Flash Chart Report Column PRODUCT #PRODUCT# #PRODUCT# PRODUCT Classic Report Column Button VIEW_PRODUCTS View Products View Products VIEW_PRODUCTS Page Button Top Orders by Date Region Definition Top Orders by Date Top Orders by Date Region no data found no data found Region Interactive Report Flash Chart Button VIEW_ORDERS View Orders View Orders VIEW_ORDERS Page Button Sample Application Region Definition Sample Application Sample Application Region Welcome to the Sample Application. This application is designed to highlight the features of Oracle Application Express. Welcome to the Sample Application. This application is designed to highlight the features of Oracle Application Express. Region Interactive Report Flash Chart Tasks Region Definition Tasks Tasks Region Interactive Report Flash Chart 2 - Customers Page Definition Customers Customers 2 - Customers Page Definition Customers Customers 2 - Customers Page Definition Help for this page Help for this page 2 - Customers Page Definition Regions Customers Region Definition Customers Customers Region Interactive Report Customers Column CUSTOMER_ID Customer ID Customer ID CUSTOMER_ID Interactive Report Column Customer ID Customer ID CUSTOMER_ID Interactive Report Column CUSTOMER_NAME Customer Name Customer Name CUSTOMER_NAME Interactive Report Column Customer Name Customer Name CUSTOMER_NAME Interactive Report Column CUSTOMER_ADDRESS Address Address CUSTOMER_ADDRESS Interactive Report Column Address Address CUSTOMER_ADDRESS Interactive Report Column CUST_CITY City City CUST_CITY Interactive Report Column City City CUST_CITY Interactive Report Column CUST_STATE State State CUST_STATE Interactive Report Column State State CUST_STATE Interactive Report Column CUST_POSTAL_CODE ZIP Code ZIP Code CUST_POSTAL_CODE Interactive Report Column ZIP Code ZIP Code CUST_POSTAL_CODE Interactive Report Column Flash Chart Button NEW Create Customer > Create Customer > NEW Page Button Page Process ApplyMRU Unable to process update. Unable to process update. ApplyMRU Page Processing #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. ApplyMRU Page Processing ApplyMRD Unable to process delete. Unable to process delete. ApplyMRD Page Processing #MRD_COUNT# row(s) deleted. #MRD_COUNT# row(s) deleted. ApplyMRD Page Processing 3 - Products Page Definition Products Products 3 - Products Page Definition Products Products 3 - Products Page Definition No help is available for this page. No help is available for this page. 3 - Products Page Definition Regions Top 5 Products Region Definition Top 5 Products Top 5 Products Region No data found. No data found. Region Interactive Report Flash Chart Products Region Definition Products Products Region Interactive Report Products Column PRODUCT_ID Product_Id Product_Id PRODUCT_ID Interactive Report Column Product_Id Product_Id PRODUCT_ID Interactive Report Column PRODUCT_NAME Name Name PRODUCT_NAME Interactive Report Column This column contains the name of a product. This column contains the name of a product. PRODUCT_NAME Interactive Report Column Name Name PRODUCT_NAME Interactive Report Column PRODUCT_DESCRIPTION Description Description PRODUCT_DESCRIPTION Interactive Report Column Description Description PRODUCT_DESCRIPTION Interactive Report Column CATEGORY Category Category CATEGORY Interactive Report Column Category Category CATEGORY Interactive Report Column PRODUCT_AVAIL Available Available PRODUCT_AVAIL Interactive Report Column Available Available PRODUCT_AVAIL Interactive Report Column LIST_PRICE Price Price LIST_PRICE Interactive Report Column Price Price LIST_PRICE Interactive Report Column UNITS Units Units UNITS Interactive Report Column Units Units UNITS Interactive Report Column SALES Sales Sales SALES Interactive Report Column Sales Sales SALES Interactive Report Column CUSTOMERS Customers Customers CUSTOMERS Interactive Report Column Customers Customers CUSTOMERS Interactive Report Column LAST_DATE_SOLD Last Sale Last Sale LAST_DATE_SOLD Interactive Report Column Last Sale Last Sale LAST_DATE_SOLD Interactive Report Column IMG Image Image IMG Interactive Report Column Image Image IMG Interactive Report Column ICON_LINK Icon Link Icon Link ICON_LINK Interactive Report Column Icon Link Icon Link ICON_LINK Interactive Report Column DETAIL_IMG Image Image DETAIL_IMG Interactive Report Column Image Image DETAIL_IMG Interactive Report Column DETAIL_IMG_NO_STYLE Detail Img No Style Detail Img No Style DETAIL_IMG_NO_STYLE Interactive Report Column Detail Img No Style Detail Img No Style DETAIL_IMG_NO_STYLE Interactive Report Column Flash Chart Button CREATE Create Product > Create Product > CREATE Page Button 4 - Orders Page Definition Orders Orders 4 - Orders Page Definition Orders Orders 4 - Orders Page Definition No help is available for this page. No help is available for this page. 4 - Orders Page Definition Regions Orders Region Definition Orders Orders Region Interactive Report My Orders Column ORDER_ID Order # Order # ORDER_ID Interactive Report Column Order # Order # ORDER_ID Interactive Report Column ORDER_TOTAL Order Total Order Total ORDER_TOTAL Interactive Report Column Order Total Order Total ORDER_TOTAL Interactive Report Column SALES_REP Sales Rep Sales Rep SALES_REP Interactive Report Column Sales Rep Sales Rep SALES_REP Interactive Report Column CUSTOMER_NAME Customer Name Customer Name CUSTOMER_NAME Interactive Report Column Customer Name Customer Name CUSTOMER_NAME Interactive Report Column ORDER_ITEMS Order Items Order Items ORDER_ITEMS Interactive Report Column Order Items Order Items ORDER_ITEMS Interactive Report Column ORDER_MONTH Order Month Order Month ORDER_MONTH Interactive Report Column Order Month Order Month ORDER_MONTH Interactive Report Column ORDER_DATE Order Date Order Date ORDER_DATE Interactive Report Column Order Date Order Date ORDER_DATE Interactive Report Column Flash Chart Button ENTER_NEW_ORDER Enter New Order > Enter New Order > ENTER_NEW_ORDER Page Button Page Process Adjust Calendar Date -Previous Error changing calendar date. Error changing calendar date. Adjust Calendar Date -Previous Page Processing Adjust Calendar Date -Today Error changing calendar date. Error changing calendar date. Adjust Calendar Date -Today Page Processing Adjust Calendar Date -Next Error changing calendar date. Error changing calendar date. Adjust Calendar Date -Next Page Processing 5 - Sales by Category / Month Page Definition Sales by Category / Month Sales by Category / Month 5 - Sales by Category / Month Page Definition Sales by Category / Month Sales by Category / Month 5 - Sales by Category / Month Page Definition No help is available for this page. No help is available for this page. 5 - Sales by Category / Month Page Definition Regions Sales by Category / Month Region Definition Sales by Category / Month Sales by Category / Month Region Interactive Report Flash Chart Sales by Category / Month Series Sales Sales Sales Sales Flash Chart (Anychart5) No data found. No data found. Sales Flash Chart (Anychart5) 6 - Product Details Page Definition Product Details Product Details 6 - Product Details Page Definition Product Details Product Details 6 - Product Details Page Definition Regions Product Details Region Definition Product Details Product Details Region Interactive Report Flash Chart Item P6_PRODUCT_IMAGE Product Image Product Image P6_PRODUCT_IMAGE Page Item P6_PRODUCT_NAME Product Name Product Name P6_PRODUCT_NAME Page Item P6_PRODUCT_DESCRIPTION Product Description Product Description P6_PRODUCT_DESCRIPTION Page Item P6_CATEGORY Category Category P6_CATEGORY Page Item P6_PRODUCT_AVAIL Product Available Product Available P6_PRODUCT_AVAIL Page Item P6_LIST_PRICE List Price List Price P6_LIST_PRICE Page Item Button CREATE Create Product Create Product CREATE Page Button SAVE Apply Changes Apply Changes SAVE Page Button DELETE Delete Delete DELETE Page Button CANCEL Cancel Cancel CANCEL Page Button Product Image Region Definition Product Image Product Image Region Interactive Report Flash Chart Button DELETE_IMAGE Delete Delete DELETE_IMAGE Page Button Page Process Delete Image Product image deleted. Product image deleted. Delete Image Page Processing Fetch Row from DEMO_PRODUCT_INFO Unable to fetch row. Unable to fetch row. Fetch Row from DEMO_PRODUCT_INFO Page Processing Process Row of DEMO_PRODUCT_INFO Unable to process row of table DEMO_PRODUCT_INFO. Unable to process row of table DEMO_PRODUCT_INFO. Process Row of DEMO_PRODUCT_INFO Page Processing Action Processed. Action Processed. Process Row of DEMO_PRODUCT_INFO Page Processing 7 - Customer Details Page Definition Customer Details Customer Details 7 - Customer Details Page Definition Customer Details Customer Details 7 - Customer Details Page Definition Regions Customer Details Region Definition Customer Details Customer Details Region Interactive Report Flash Chart Item P7_CUST_FIRST_NAME First Name First Name P7_CUST_FIRST_NAME Page Item P7_CUST_LAST_NAME Last Name Last Name P7_CUST_LAST_NAME Page Item P7_CUST_STREET_ADDRESS1 Street Address Street Address P7_CUST_STREET_ADDRESS1 Page Item P7_CUST_STREET_ADDRESS2 Line 2 Line 2 P7_CUST_STREET_ADDRESS2 Page Item P7_CUST_CITY City City P7_CUST_CITY Page Item P7_CUST_STATE - Choose State - - Choose State - P7_CUST_STATE Page Item State State P7_CUST_STATE Page Item P7_CUST_POSTAL_CODE Postal Code Postal Code P7_CUST_POSTAL_CODE Page Item P7_PHONE_NUMBER1 Phone Number Phone Number P7_PHONE_NUMBER1 Page Item P7_PHONE_NUMBER2 Alternate Number Alternate Number P7_PHONE_NUMBER2 Page Item P7_CREDIT_LIMIT Credit Limit Credit Limit P7_CREDIT_LIMIT Page Item P7_CUST_EMAIL Email Email P7_CUST_EMAIL Page Item Button CREATE Create Customer Create Customer CREATE Page Button SAVE Apply Changes Apply Changes SAVE Page Button DELETE Delete Delete DELETE Page Button CANCEL Cancel Cancel CANCEL Page Button Orders for this Customer Region Definition Order Total: Order Total: Region Orders for this Customer Orders for this Customer Region There are no orders for this customer. There are no orders for this customer. Region Total for All Orders: Total for All Orders: Region Interactive Report Flash Chart Report Column EDIT Order # Order # EDIT Classic Report Column QUANTITY Quantity Quantity QUANTITY Classic Report Column UNIT_PRICE Unit Price Unit Price UNIT_PRICE Classic Report Column PRODUCT_NAME Product Name Product Name PRODUCT_NAME Classic Report Column EXT_PRICE Extended Price Extended Price EXT_PRICE Classic Report Column USER_NAME Sales Rep Sales Rep USER_NAME Classic Report Column ORDER_TIMESTAMP Order Date Order Date ORDER_TIMESTAMP Classic Report Column New Customer Region Definition New Customer New Customer Region <p>Enter the new customer details. Please ensure these details are correct as they are used for ordering and invoicing.</p><p>Where possible obtain the customer phone number(s) to aid in contacting the customer at a later date.</p> <p>Enter the new customer details. Please ensure these details are correct as they are used for ordering and invoicing.</p><p>Where possible obtain the customer phone number(s) to aid in contacting the customer at a later date.</p> Region Interactive Report Flash Chart Page Process Fetch Row from DEMO_CUSTOMERS Unable to fetch row. Unable to fetch row. Fetch Row from DEMO_CUSTOMERS Page Processing Process Row of DEMO_CUSTOMERS Unable to process row of table DEMO_CUSTOMERS. Unable to process row of table DEMO_CUSTOMERS. Process Row of DEMO_CUSTOMERS Page Processing Customer Record Processed. Customer Record Processed. Process Row of DEMO_CUSTOMERS Page Processing Page Validation Credit Limit <= 5000 A customer's Credit Limit must be less than or equal to $5,000 A customer's Credit Limit must be less than or equal to $5,000 Credit Limit <= 5000 Page Validation P7_PHONE_NUMBER1 Phone number format not recognized Phone number format not recognized P7_PHONE_NUMBER1 Page Validation P7_PHONE_NUMBER2 Phone number format not recognized Phone number format not recognized P7_PHONE_NUMBER2 Page Validation Can't Delete Customer with Orders Can't delete customer with existing orders. Can't delete customer with existing orders. Can't Delete Customer with Orders Page Validation 8 - Manage Users Page Definition Manage Users Manage Users 8 - Manage Users Page Definition Manage Users Manage Users 8 - Manage Users Page Definition Regions Manage Users Region Definition Manage Users Manage Users Region Report returned no rows. Report returned no rows. Region Interactive Report Flash Chart Report Column USER_ID User Id User Id USER_ID Classic Report Column USER_NAME User Name User Name USER_NAME Classic Report Column CREATED_ON Created Created CREATED_ON Classic Report Column QUOTA Quota Quota QUOTA Classic Report Column CHECK$01 &nbsp; &nbsp; CHECK$01 Classic Report Column RP Reset Password Reset Password RP Classic Report Column #RP# #RP# RP Classic Report Column PRODUCTS Edit Products Edit Products PRODUCTS Classic Report Column EXPIRES_ON Expires On Expires On EXPIRES_ON Classic Report Column ADMIN_USER Admin User Admin User ADMIN_USER Classic Report Column Button CANCEL Cancel Cancel CANCEL Page Button SUBMIT Save Changes Save Changes SUBMIT Page Button MULTI_ROW_DELETE Remove Selected Users Remove Selected Users MULTI_ROW_DELETE Page Button ADD Add User Add User ADD Page Button Page Process ApplyMRU Unable to process update Unable to process update ApplyMRU Page Processing #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. ApplyMRU Page Processing ApplyMRD Unable to process delete Unable to process delete ApplyMRD Page Processing #MRD_COUNT# row(s) deleted. #MRD_COUNT# row(s) deleted. ApplyMRD Page Processing ApplyMRU Unable to process update Unable to process update ApplyMRU Page Processing #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. ApplyMRU Page Processing AddRows Unable to add rows Unable to add rows AddRows Page Processing Page Validation USER_NAME Not Null #COLUMN_HEADER# must have a value. #COLUMN_HEADER# must have a value. USER_NAME Not Null Page Validation EXPIRES_ON is date #COLUMN_HEADER# must be a date. #COLUMN_HEADER# must be a date. EXPIRES_ON is date Page Validation QUOTA is numeric #COLUMN_HEADER# must be numeric. #COLUMN_HEADER# must be numeric. QUOTA is numeric Page Validation PRODUCTS not null #COLUMN_HEADER# must have a value. #COLUMN_HEADER# must have a value. PRODUCTS not null Page Validation 9 - Reset Password Page Definition Reset Password Reset Password 9 - Reset Password Page Definition Reset Password Reset Password 9 - Reset Password Page Definition Regions Reset Password for &P9_USER_NAME. Region Definition Reset Password for &P9_USER_NAME. Reset Password for &P9_USER_NAME. Region Interactive Report Flash Chart Item P9_NEW_PW Enter New Password Enter New Password P9_NEW_PW Page Item P9_NEW_PW_2 Re-Enter New Password Re-Enter New Password P9_NEW_PW_2 Page Item Button RESET_PW Reset Password Reset Password RESET_PW Page Button CANCEL Cancel Cancel CANCEL Page Button Error! Region Definition Error! Error! Region You cannot reset the password before you Apply Changes to a new user. You cannot reset the password before you Apply Changes to a new user. Region Interactive Report Flash Chart Page Process Update Password Password for &P9_USER_NAME. Updated. Password for &P9_USER_NAME. Updated. Update Password Page Processing Page Validation Passwords Must Match Your passwords must be the same. Please re-enter. Your passwords must be the same. Please re-enter. Passwords Must Match Page Validation 10 - Order Calendar Page Definition Order Calendar Order Calendar 10 - Order Calendar Page Definition Order Calendar Order Calendar 10 - Order Calendar Page Definition Regions Order Calendar Region Definition Order Calendar Order Calendar Region Interactive Report Flash Chart Button PREVIOUS < Previous < Previous PREVIOUS Page Button TODAY Today Today TODAY Page Button NEXT Next > Next > NEXT Page Button 11 - Enter New Order Page Definition Enter New Order Enter New Order 11 - Enter New Order Page Definition Enter New Order Enter New Order 11 - Enter New Order Page Definition Regions Identify Customer Region Definition Identify Customer Identify Customer Region Interactive Report Flash Chart Item P11_CUSTOMER_ID Customer Customer P11_CUSTOMER_ID Page Item P11_CUSTOMER_OPTIONS Create Order for: Create Order for: P11_CUSTOMER_OPTIONS Page Item Button NEXT Next > Next > NEXT Page Button CANCEL Cancel Cancel CANCEL Page Button Order Progress Region Definition Order Progress Order Progress Region Interactive Report Flash Chart Page Validation P11_CUSTOMER_ID Please select a customer Please select a customer P11_CUSTOMER_ID Page Validation 12 - Enter New Order Page Definition Enter New Order Enter New Order 12 - Enter New Order Page Definition Enter New Order Enter New Order 12 - Enter New Order Page Definition Regions Select Items Region Definition Select Items Select Items Region Interactive Report Flash Chart Button PLACE_ORDER Place Order Place Order PLACE_ORDER Page Button CANCEL Cancel Cancel CANCEL Page Button PREVIOUS < Previous < Previous PREVIOUS Page Button Order Progress Region Definition Order Progress Order Progress Region Interactive Report Flash Chart 13 - Customer Map Page Definition Customer Map Customer Map 13 - Customer Map Page Definition Customer Map Customer Map 13 - Customer Map Page Definition No help is available for this page. No help is available for this page. 13 - Customer Map Page Definition Regions Customer Map Region Definition Customer Map Customer Map Region Interactive Report Flash Chart Customer Map Series Series 1 Series 1 Series 1 Series 1 Flash Chart (Anychart5) No customers found. No customers found. Series 1 Flash Chart (Anychart5) 14 - Order Summary Page Definition Order Summary Order Summary 14 - Order Summary Page Definition Order Summary Order Summary 14 - Order Summary Page Definition Regions Order Header Region Definition Order Header Order Header Region Interactive Report Flash Chart Order Lines Region Definition Order Lines Order Lines Region no data found no data found Region Report Total Report Total Region Interactive Report Flash Chart Report Column UNIT_PRICE Unit Price Unit Price UNIT_PRICE Classic Report Column QUANTITY Quantity Quantity QUANTITY Classic Report Column PRODUCT_NAME Product Name Product Name PRODUCT_NAME Classic Report Column EXTENEDED_PRICE Exteneded Price Exteneded Price EXTENEDED_PRICE Classic Report Column Order Progress Region Definition Order Progress Order Progress Region Interactive Report Flash Chart Order Summary Region Definition Order Summary Order Summary Region Interactive Report Flash Chart Button RETURN View Orders View Orders RETURN Page Button HOME Home Home HOME Page Button 16 - Sales by Category and Product Page Definition Sales by Category and Product Sales by Category and Product 16 - Sales by Category and Product Page Definition Sales by Category and Product Sales by Category and Product 16 - Sales by Category and Product Page Definition Regions Sales by Category Region Definition Sales by Category Sales by Category Region Interactive Report Flash Chart Sales by Category Series Categories Categories Categories Categories Flash Chart (Anychart5) no data found no data found Categories Flash Chart (Anychart5) Sales by Product Region Definition Sales by Product Sales by Product Region Interactive Report Flash Chart Sales by Product Series Series 1 Series 1 Series 1 Series 1 Flash Chart (Anychart5) No data found. No data found. Series 1 Flash Chart (Anychart5) 17 - Customer Orders Page Definition Customer Orders Customer Orders 17 - Customer Orders Page Definition Customer Orders Customer Orders 17 - Customer Orders Page Definition Regions Customer Orders Region Definition Customer Orders Customer Orders Region Interactive Report Flash Chart Customer Orders Series Series 1 Series 1 Series 1 Series 1 Flash Chart (Anychart5) No data found. No data found. Series 1 Flash Chart (Anychart5) 18 - Enter New Order Page Definition Enter New Order Enter New Order 18 - Enter New Order Page Definition Enter New Order Enter New Order 18 - Enter New Order Page Definition Regions Customer Details Region Definition Customer Details Customer Details Region Interactive Report Flash Chart Item P18_CUST_FIRST_NAME First Name First Name P18_CUST_FIRST_NAME Page Item P18_CUST_LAST_NAME Last Name Last Name P18_CUST_LAST_NAME Page Item P18_CUST_STREET_ADDRESS1 Street Address Street Address P18_CUST_STREET_ADDRESS1 Page Item P18_CUST_STREET_ADDRESS2 Line 2 Line 2 P18_CUST_STREET_ADDRESS2 Page Item P18_CUST_CITY City City P18_CUST_CITY Page Item P18_CUST_STATE - Choose State - - Choose State - P18_CUST_STATE Page Item State State P18_CUST_STATE Page Item P18_CUST_EMAIL Email Email P18_CUST_EMAIL Page Item P18_PHONE_NUMBER1 Phone Number Phone Number P18_PHONE_NUMBER1 Page Item P18_PHONE_NUMBER2 Alternate Number Alternate Number P18_PHONE_NUMBER2 Page Item P18_CREDIT_LIMIT Credit Limit Credit Limit P18_CREDIT_LIMIT Page Item P18_CUST_POSTAL_CODE Postal Code Postal Code P18_CUST_POSTAL_CODE Page Item Button INSERT Next > Next > INSERT Page Button CANCEL Cancel Cancel CANCEL Page Button PREVIOUS < Previous < Previous PREVIOUS Page Button Order Progress Region Definition Order Progress Order Progress Region Interactive Report Flash Chart New Customer Region Definition New Customer New Customer Region <p>Enter the new customer details. Please ensure these details are correct as they are used for ordering and invoicing.</p><p>Where possible obtain the customer phone number(s) to aid in contacting the customer at a later date.</p> <p>Enter the new customer details. Please ensure these details are correct as they are used for ordering and invoicing.</p><p>Where possible obtain the customer phone number(s) to aid in contacting the customer at a later date.</p> Region Interactive Report Flash Chart Order Progress Region Definition Order Progress Order Progress Region Interactive Report Flash Chart Page Process Fetch Row from DEMO_CUSTOMERS Unable to fetch row. Unable to fetch row. Fetch Row from DEMO_CUSTOMERS Page Processing Process Row of DEMO_CUSTOMERS Unable to process row of table DEMO_CUSTOMERS. Unable to process row of table DEMO_CUSTOMERS. Process Row of DEMO_CUSTOMERS Page Processing Page Validation Credit Limit <= 5000 A customer's Credit Limit must be less than or equal to $5,000 A customer's Credit Limit must be less than or equal to $5,000 Credit Limit <= 5000 Page Validation P18_PHONE_NUMBER1 Phone number format not recognized Phone number format not recognized P18_PHONE_NUMBER1 Page Validation P18_PHONE_NUMBER2 Phone number format not recognized Phone number format not recognized P18_PHONE_NUMBER2 Page Validation 19 - Product Order Tree Page Definition Product Order Tree Product Order Tree 19 - Product Order Tree Page Definition Product Order Tree Product Order Tree 19 - Product Order Tree Page Definition No help is available for this page. No help is available for this page. 19 - Product Order Tree Page Definition Regions Product Order Tree Region Definition Product Order Tree Product Order Tree Region No data found. No data found. Region Interactive Report Flash Chart Button CONTRACT_ALL Collapse All Collapse All CONTRACT_ALL Page Button EXPAND_ALL Expand All Expand All EXPAND_ALL Page Button 20 - Product Info Page Definition Product Info Product Info 20 - Product Info Page Definition Product Info Product Info 20 - Product Info Page Definition Regions Product Image Region Definition Product Image Product Image Region no data found no data found Region Interactive Report Flash Chart Report Column IMAGE Image Image IMAGE Classic Report Column Product Information Region Definition Product Information Product Information Region no data found no data found Region Interactive Report Flash Chart Report Column PRODUCT_NAME Product Name Product Name PRODUCT_NAME Classic Report Column PRODUCT_DESCRIPTION Description Description PRODUCT_DESCRIPTION Classic Report Column CATEGORY Category Category CATEGORY Classic Report Column LIST_PRICE List Price List Price LIST_PRICE Classic Report Column Button CLOSE Close this Window Close this Window CLOSE Page Button 29 - Order Details Page Definition Order Details Order Details 29 - Order Details Page Definition Order Details Order Details 29 - Order Details Page Definition No help is available for this page. No help is available for this page. 29 - Order Details Page Definition Regions Order #&P29_ORDER_ID. Region Definition Order #&P29_ORDER_ID. Order #&P29_ORDER_ID. Region Interactive Report Flash Chart Item P29_ORDER_TOTAL Order Total Order Total P29_ORDER_TOTAL Page Item P29_ORDER_TIMESTAMP Order Date Order Date P29_ORDER_TIMESTAMP Page Item P29_USER_ID Sales Rep Sales Rep P29_USER_ID Page Item P29_CUSTOMER_INFO Customer Info Customer Info P29_CUSTOMER_INFO Page Item Button CREATE Create Create CREATE Page Button SAVE Save Changes Save Changes SAVE Page Button DELETE Delete Order Delete Order DELETE Page Button CANCEL Cancel Cancel CANCEL Page Button GET_NEXT_ORDER_ID > > GET_NEXT_ORDER_ID Page Button GET_PREVIOUS_ORDER_ID < < GET_PREVIOUS_ORDER_ID Page Button Items for Order #&P29_ORDER_ID. Region Definition Items for Order #&P29_ORDER_ID. Items for Order #&P29_ORDER_ID. Region There are no items associated with this Order. There are no items associated with this Order. Region &nbsp; &nbsp; Region Interactive Report Flash Chart Report Column PRODUCT_IMAGE Product Image Product Image PRODUCT_IMAGE Classic Report Column ORDER_ITEM_ID Order Item Id Order Item Id ORDER_ITEM_ID Classic Report Column ORDER_ID Order Id Order Id ORDER_ID Classic Report Column PRODUCT_ID Product Name Product Name PRODUCT_ID Classic Report Column UNIT_PRICE Unit Price Unit Price UNIT_PRICE Classic Report Column QUANTITY Quantity Quantity QUANTITY Classic Report Column CHECK$01 &nbsp; &nbsp; CHECK$01 Classic Report Column EXTENDED_PRICE Extended Price Extended Price EXTENDED_PRICE Classic Report Column DETAIL_IMG Product Image Product Image DETAIL_IMG Classic Report Column Button APPLY_CHANGES_MRD Delete Checked Items Delete Checked Items APPLY_CHANGES_MRD Page Button ADD_CHANGES_ADD Add Item to Order Add Item to Order ADD_CHANGES_ADD Page Button Page Process Fetch Row from DEMO_ORDERS Unable to fetch row. Unable to fetch row. Fetch Row from DEMO_ORDERS Page Processing Process Row of DEMO_ORDERS Unable to process row of table DEMO_ORDERS. Unable to process row of table DEMO_ORDERS. Process Row of DEMO_ORDERS Page Processing Action Processed. Action Processed. Process Row of DEMO_ORDERS Page Processing Get Next or Previous Primary Key Value Unable to run Get Next or Previous Primary Key Value process. Unable to run Get Next or Previous Primary Key Value process. Get Next or Previous Primary Key Value Page Processing ApplyMRU Unable to process update Unable to process update ApplyMRU Page Processing #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. #MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted. ApplyMRU Page Processing ApplyMRD Unable to process delete Unable to process delete ApplyMRD Page Processing #MRD_COUNT# row(s) deleted. #MRD_COUNT# row(s) deleted. ApplyMRD Page Processing AddRows Unable to add rows Unable to add rows AddRows Page Processing 101 - Login Page Definition Login Login 101 - Login Page Definition Login Login 101 - Login Page Definition Regions Login Region Definition Login Login Region <hr />By default, two accounts are created in the Sample Application: <span class="fielddatabold">demo</span> and <span class="fielddatabold">admin</span>. The default password for both accounts is the all lowercase name of the workspace in which this application is located. <p />Please refer to the section "Understanding Sample Application" in the Oracle Help or Oracle User's Guide for more information. <hr />By default, two accounts are created in the Sample Application: <span class="fielddatabold">demo</span> and <span class="fielddatabold">admin</span>. The default password for both accounts is the all lowercase name of the workspace in which this application is located. <p />Please refer to the section "Understanding Sample Application" in the Oracle Help or Oracle User's Guide for more information. Region Interactive Report Flash Chart Item P101_USERNAME User Name User Name P101_USERNAME Page Item P101_PASSWORD Password Password P101_PASSWORD Page Item P101_LOGIN Login Login P101_LOGIN Page Item 102 - Feedback Page Definition Feedback Feedback 102 - Feedback Page Definition Feedback Feedback 102 - Feedback Page Definition Regions Feedback Region Definition Feedback Feedback Region Interactive Report Flash Chart Item P102_APPLICATION_ID Application: Application: P102_APPLICATION_ID Page Item P102_PAGE_ID Page: Page: P102_PAGE_ID Page Item P102_FEEDBACK Feedback Feedback P102_FEEDBACK Page Item P102_FEEDBACK_TYPE Feedback Type Feedback Type P102_FEEDBACK_TYPE Page Item Button SUBMIT Submit Feedback Submit Feedback SUBMIT Page Button CANCEL Cancel Cancel CANCEL Page Button