DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_MATERIAL_STATUSES_TL

Line 3793: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3789: , milv.locator_segments concatenated_segments
3790: , milv.description
3791: , 0 dummy
3792: , mmsv.status_code
3793: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3794: WHERE milv.organization_id = p_organization_id
3795: AND milv.subinventory_code = p_subinventory_code
3796: AND milv.concatenated_segments LIKE (p_concatenated_segments)
3797: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )

Line 3839: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3835: , milv.locator_segments concatenated_segments
3836: , milv.description
3837: , 0 dummy
3838: , mmsv.status_code
3839: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3840: WHERE milv.organization_id = p_organization_id
3841: AND milv.subinventory_code = p_subinventory_code
3842: AND milv.alias = p_alias
3843: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )