DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 121: FROM oe_order_headers_all

117:
118:
119: CURSOR Get_order_header_id(p_order_number IN NUMBER ,p_order_type_id IN NUMBER,p_header_id IN NUMBER) IS
120: SELECT header_id
121: FROM oe_order_headers_all
122: WHERE p_header_id IS NOT NULL
123: AND header_id = p_header_id
124: UNION ALL
125: SELECT header_id

Line 126: FROM oe_order_headers_all

122: WHERE p_header_id IS NOT NULL
123: AND header_id = p_header_id
124: UNION ALL
125: SELECT header_id
126: FROM oe_order_headers_all
127: WHERE p_header_id IS NULL
128: AND order_number = p_order_number
129: AND order_type_id = p_order_type_id;
130: