DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on RCV_SUPPLY

Line 3097: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3093: SELECT 1
3094: INTO l_exist
3095: FROM dual
3096: WHERE exists (SELECT '1'
3097: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3098: WHERE wlpn.lpn_id = l_lpn_id
3099: AND wlpn.lpn_id = rs.lpn_id
3100: AND rs.location_id <> l_location_id);
3101: ELSE

Line 3106: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3102: SELECT 1
3103: INTO l_exist
3104: FROM dual
3105: WHERE exists (SELECT '1'
3106: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3107: WHERE wlpn.license_plate_number = l_lpn_num
3108: AND wlpn.lpn_id = rs.lpn_id
3109: AND rs.location_id <> l_location_id);
3110: END IF;

Line 3341: , rcv_supply rs

3337: , rt.organization_id
3338: FROM rcv_transactions rt
3339: , mtl_parameters mp
3340: , mtl_system_items_kfv msi
3341: , rcv_supply rs
3342: WHERE mp.wms_enabled_flag = 'Y'
3343: AND mp.organization_id = rt.organization_id
3344: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT')
3345: AND rs.rcv_transaction_id = rt.transaction_id