APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 132: FROM JAI_OM_WSH_LINES_ALL

128:
129:
130: CURSOR c_source_orgn_loc(cp_shipment_hdr_id IN NUMBER, cp_req_line_id IN NUMBER) IS
131: SELECT organization_id, location_id
132: FROM JAI_OM_WSH_LINES_ALL
133: WHERE delivery_id = ( SELECT
134: decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,rsh.shipment_num,
135: (select delivery_id
136: from wsh_new_deliveries