DBA Data[Home] [Help]

APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on OE_ORDER_HEADERS_ALL

Line 118: FROM oe_order_headers_all

114: IS
115:
116: CURSOR get_order_number (X_order_header_id in number) is
117: SELECT order_number
118: FROM oe_order_headers_all
119: WHERE header_id = X_order_header_id;
120:
121: -- Bug# 1577520 - Pass the Batch Name to MoveOrderHeader, instead of Batch Id
122: -- Prasanna Vanguri 5th March'01

Line 129: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

125: FROM wsh_picking_batches
126: WHERE batch_id = X_batch_id;
127:
128: l_batch_name varchar2(30);
129: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
130: l_report_set_id NUMBER;
131: l_trip_ids WSH_UTIL_CORE.Id_Tab_Type;
132: l_stop_ids WSH_UTIL_CORE.Id_Tab_Type;
133: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;