DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on WMS_LPN_CONTENTS_V

Line 8113: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh

8109: , x_msg_data OUT NOCOPY VARCHAR2
8110: ) IS
8111: CURSOR l_curs_remaining_asn IS --modified for bug 4951745
8112: SELECT 1
8113: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8114: WHERE (lpn.source_header_id = rsh.shipment_header_id
8115: OR lpn.source_name = rsh.shipment_num)
8116: AND rsh.shipment_header_id = p_shipment_header_id
8117: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)

Line 8130: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh

8126:
8127: --Added for Bug 4951745
8128: CURSOR l_curs_remaining_asn_has_lpn IS
8129: SELECT 1
8130: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8131: WHERE (lpn.source_header_id = rsh.shipment_header_id
8132: OR lpn.source_name = rsh.shipment_num)
8133: AND rsh.shipment_header_id = p_shipment_header_id
8134: AND lpn.lpn_id = p_lpn_id