DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on OE_SETS

Line 133: FROM OE_SETS

129: AND order_type_id = p_order_type_id;
130:
131: CURSOR Get_Ship_Set_Id(p_ship_set_id IN NUMBER, p_ship_set_number IN VARCHAR2, p_header_id IN NUMBER) IS
132: SELECT set_id
133: FROM OE_SETS
134: WHERE p_ship_set_id IS NOT NULL
135: AND set_id = p_ship_set_id
136: UNION ALL
137: SELECT set_id

Line 138: FROM OE_SETS

134: WHERE p_ship_set_id IS NOT NULL
135: AND set_id = p_ship_set_id
136: UNION ALL
137: SELECT set_id
138: FROM OE_SETS
139: WHERE p_ship_set_id IS NULL
140: AND header_id = p_header_id
141: AND set_name = p_ship_set_number
142: AND set_type = 'SHIP_SET';