DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 119: FROM oe_order_headers_all

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

Line 124: FROM oe_order_headers_all

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