<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS
|
View
|
View
|
<DEFAULT SCHEMA>.TRG_ORDER
|
Trigger
|
Simple Trigger of BEFORE "INSERT on sales_order_items"
|
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS
|
Trigger
|
Simple Trigger of BEFORE "DELETE on sales_order_items"
|
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1
|
Cursor
|
PLSQL Cursor defined in PRODUCTS.ProductsByCustomer
|
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS_LINEID
|
Index
|
|
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS.NEW
|
PseudoRecord
|
SALES_ORDER_ITEMS
|
<DEFAULT SCHEMA>.TRG_ORDER.NEW
|
PseudoRecord
|
SALES_ORDER_ITEMS
|
<DEFAULT SCHEMA>.TRG_ORDER.OLD
|
PseudoRecord
|
SALES_ORDER_ITEMS
|
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS.OLD
|
PseudoRecord
|
SALES_ORDER_ITEMS
|
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderItemById.Delete
|
Delete Statement
|
DELETE sales_order_items where id = orderId
|
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2.Select
|
Select Statement
|
SELECT sales_order.id Oid, sales_order.order_date Odate, DECODE(sales_order.fi
|
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1.Select
|
Select Statement
|
SELECT product.id Pid, product.name prod_name, sum (sales_order_items.quantity*unit_price) P
|
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select
|
Select Statement
|
SELECT Count(*) into Prod_num FROM customer, product, sales_order_items,
|
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.Select
|
Select Statement
|
SELECT sales_order.id, sales_order.order_date, sales_order.fin_code_id, sales_
|
<DEFAULT SCHEMA>.PRODUCTSBYCUSTOMER.Select
|
Select Statement
|
SELECT product.* FROM SALES_ORDER_ITEMS join customer c on customerId = c.id join SALES_
|
d_tab_sales_order_items.sales_order_items_id
|
Datawindow Column UI
|
|
d_tab_sales_order_items.sales_order_items_line_id
|
Datawindow Column UI
|
|
d_tab_sales_order_items.sales_order_items_prod_id
|
Datawindow Column UI
|
|
d_tab_sales_order_items.sales_order_items_quantity
|
Datawindow Column UI
|
|
d_tab_sales_order_items.sales_order_items_ship_date
|
Datawindow Column UI
|
|
d_tab_sales_order_items.table.update
|
Datawindow Attribute
|
|
d_tab_sales_order_items.Retrieve SQL
|
Datawindow DataSource
|
|
d_tab_sales_order.Retrieve SQL
|
Datawindow DataSource
|
|