DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on WMS_LPN_CONTENTS_V

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

8505: , x_msg_data OUT NOCOPY VARCHAR2
8506: ) IS
8507: CURSOR l_curs_remaining_asn IS --modified for bug 4951745
8508: SELECT 1
8509: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8510: WHERE (lpn.source_header_id = rsh.shipment_header_id
8511: OR lpn.source_name = rsh.shipment_num)
8512: AND rsh.shipment_header_id = p_shipment_header_id
8513: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)

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

8522:
8523: --Added for Bug 4951745
8524: CURSOR l_curs_remaining_asn_has_lpn IS
8525: SELECT 1
8526: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8527: WHERE (lpn.source_header_id = rsh.shipment_header_id
8528: OR lpn.source_name = rsh.shipment_num)
8529: AND rsh.shipment_header_id = p_shipment_header_id
8530: AND lpn.lpn_id = p_lpn_id