Order Managerment Status flow

 

Order&Shipping Transactions Status Summary

Step	Order Header Status	Order Line Status	Order Flow Workflow Status (Order Header)	Line Flow Workflow Status (Order Line)	Shipping Transaction  Status(RELEASED_STATUS in WDD)
1. Enter an Order	Entered	Entered	Book Order Manual	Enter – Line	N/A
2. Book the Order	Booked	Awaiting Shipping	Close Order	Schedule ->Create Supply ->Ship – Line	Ready to Release(R)
3. Pick the Order	Booked	Picked	Close Order	Ship – Line	1.Released to Warehouse(S)(Pick Release but not pick confirm)  2.Staged/Pick Confirmed(Y)(After pick confirm)
4. Ship the Order	Booked	Shipped	Close Order	Fulfill – Deferred	1.Shipped(After ship confirm)  2.Interfaced(C)(After ITS)
	Booked	Closed	Close Order	Fulfill ->Invoice Interface ->Close Line -> End
5. Close the Order	Closed	Closed	End	End

Declare Array in PL/SQL

 

-- declare NUMBER of Array TYPE and Parameter

TYPE t_number_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
number_array          t_number_array;

-- declare VARCHAR2 的 Array TYPE and Parameter

TYPE t_varchar2_array IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
string_array          t_varchar2_array;

-- 塞值進 Number Array 
number_array(1) := 123;
number_array(2) := 456;
number_array(3) := 789;

Re-open Inventory accounting period

Re-open Inventory accounting period

2. SELECT acct_period_id period, open_flag, period_name name,
period_start_date, schedule_close_date, period_close_date
FROM org_acct_periods
WHERE organization_id = &org_id
order by 1,2;

3. UPDATE org_acct_periods
SET open_flag = 'Y',
period_close_date = NULL,
summarized_flag = 'N'
WHERE organization_id = &&org_id
AND acct_period_id >= &&acct_period_id;



DELETE mtl_period_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;



DELETE mtl_period_cg_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;



DELETE mtl_per_close_dtls
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;



DELETE cst_period_close_summary
WHERE organization_id = &org_id
AND acct_period_id >= &acct_period_id;