DBA Data[Home] [Help]

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 117: FROM JAI_OM_WSH_LINES_ALL

113:
114:
115: CURSOR c_source_orgn_loc(cp_shipment_hdr_id IN NUMBER, cp_req_line_id IN NUMBER) IS
116: SELECT organization_id, location_id
117: FROM JAI_OM_WSH_LINES_ALL
118: WHERE delivery_id = ( SELECT
119: decode(ltrim(translate(shipment_num,'0123456789','~'),'~'),NULL,rsh.shipment_num,
120: (select delivery_id
121: from wsh_new_deliveries