DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_PARAMETERS

Line 3331: mtl_parameters mp

3327: 'REJECT','INSPECT',
3328: 'DELIVER', DECODE (mp.wms_enabled_flag,'Y','PUTAWAY','DELIVER'),
3329: transaction_type) transaction_type
3330: FROM rcv_transactions rt,
3331: mtl_parameters mp
3332: WHERE rt.group_id = p_group_id
3333: AND rt.organization_id = mp.organization_id;
3334:
3335: CURSOR c_pregen_cursor IS

Line 3339: , mtl_parameters mp

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