DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on OE_SETS

Line 131: FROM OE_SETS

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

Line 136: FROM OE_SETS

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