GetAllItems | |
|
<DEFAULT SERVER> > <DEFAULT DATABASE> > <DEFAULT SCHEMA> > SALEORDER > GetAllItems |
Procedure body GetAllItems(orderId NUMBER), Package SALEORDER
Name | Datatype | Precision | Description |
---|---|---|---|
orderId | NUMBER | NUMBER, parameter of SALEORDER.GetAllItems |
Name | Types | Value | ||||
---|---|---|---|---|---|---|
r1 | Variable | |||||
Impact Analysis: |
|
Name | Definition |
---|---|
c1 | cursor c1 is SELECT Id, order_date, fin_code_id, region,item_id,product_name, prod_size,Total_HT FROM ALL_Sales_Order_Items_DETAILS Where Id = orderId; |
procedure GetAllItems( orderId in NUMBER )
is
cursor c1 is
SELECT Id, order_date, fin_code_id, region,item_id,product_name, prod_size,Total_HT
FROM ALL_Sales_Order_Items_DETAILS Where Id = orderId;
begin
for r1 in c1 loop
dbms_output.put_line(
lpad(r1.ID,12)
);
end loop;
end GetAllItems
Name | Types | Description |
---|---|---|
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS | View | View |
<DEFAULT SCHEMA>.SALEORDER.GetAllItems | Procedure | Procedure interface GetAllItems(orderId NUMBER), Package SALEORDER |
LPAD | Function | PL/SQL System Function |
DBMS_OUTPUT.PUT_LINE | Function | PL/SQL System Function |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.FIN_CODE_ID | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.ID | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.ITEM_ID | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.ORDER_DATE | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.PROD_SIZE | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.PRODUCT_NAME | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.REGION | Column | View column |
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.TOTAL_HT | Column | View column |
NUMBER | PL/SQL System type | PL/SQL System Object |
PUBLIC.DBMS_OUTPUT | Synonym | PL/SQL System Synonym |
No Data |
---|