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:
Object calling \"r1\" Object Type
<DEFAULT SCHEMA>.SALEORDER.GetAllItems Procedure
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