DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on RCV_SUPPLY

Line 3068: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3064: SELECT 1
3065: INTO l_exist
3066: FROM dual
3067: WHERE exists (SELECT '1'
3068: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3069: WHERE wlpn.lpn_id = l_lpn_id
3070: AND wlpn.lpn_id = rs.lpn_id
3071: AND rs.location_id <> l_location_id);
3072: ELSE

Line 3077: FROM rcv_supply rs, wms_license_plate_numbers wlpn

3073: SELECT 1
3074: INTO l_exist
3075: FROM dual
3076: WHERE exists (SELECT '1'
3077: FROM rcv_supply rs, wms_license_plate_numbers wlpn
3078: WHERE wlpn.license_plate_number = l_lpn_num
3079: AND wlpn.lpn_id = rs.lpn_id
3080: AND rs.location_id <> l_location_id);
3081: END IF;

Line 3312: , rcv_supply rs

3308: , rt.organization_id
3309: FROM rcv_transactions rt
3310: , mtl_parameters mp
3311: , mtl_system_items_kfv msi
3312: , rcv_supply rs
3313: WHERE mp.wms_enabled_flag = 'Y'
3314: AND mp.organization_id = rt.organization_id
3315: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT')
3316: AND rs.rcv_transaction_id = rt.transaction_id