DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_PARAMETERS

Line 3302: mtl_parameters mp

3298: 'REJECT','INSPECT',
3299: 'DELIVER', DECODE (mp.wms_enabled_flag,'Y','PUTAWAY','DELIVER'),
3300: transaction_type) transaction_type
3301: FROM rcv_transactions rt,
3302: mtl_parameters mp
3303: WHERE rt.group_id = p_group_id
3304: AND rt.organization_id = mp.organization_id;
3305:
3306: CURSOR c_pregen_cursor IS

Line 3310: , mtl_parameters mp

3306: CURSOR c_pregen_cursor IS
3307: SELECT DISTINCT rt.transfer_lpn_id
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